pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: pgsql-sql <pgsql-sql@fc.emc.com.ph>
To: pgsql-sql@postgresql.org
Subject: trigger output to a file
Date: Fri, 23 Mar 2001 15:15:02 +0800
Message-ID: <fc.000f567200a768bb000f567200a768bb.a7696b@fc.emc.com.ph> (raw)

Hello Everyone,

Here's my simple question.

I just want to know/get the recent changes made to a table.
Deeper? I wanted the Postgresql server to *publish* every
changes made to a table (similar to replication, incremental transfer,
etc.).
What is the best way to go about it?

My idea is to create a trigger for every insert/update that will
select the new/updated record and output it to a file. Or better
yet, I would like to output the actual sql query to file.
Is it possible to output the result of an sql query from a trigger
to a file? How?

I would appreciate any answer. Thank you very much.
Sherwin




view thread (3+ messages)  latest in thread

Message-ID: <fc.000f567200a768bb000f567200a768bb.a7696b@fc.emc.com.ph>
Permalink:  ../fc.000f567200a768bb000f567200a768bb.a7696b@fc.emc.com.ph/
Also on:    postgresql.org/message-id/fc.000f567200a768bb000f567200a768bb.a7696b@fc.emc.com.ph

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-sql@postgresql.org
  Cc: pgsql-sql@fc.emc.com.ph
  Subject: Re: trigger output to a file
  In-Reply-To: <fc.000f567200a768bb000f567200a768bb.a7696b@fc.emc.com.ph>
  References: <fc.000f567200a768bb000f567200a768bb.a7696b@fc.emc.com.ph>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox