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
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