Thread: automatically dump a table when it is updated

automatically dump a table when it is updated

From

"Keith Worthington"

Date:

28 February 2007, 03:32:22

Hi All,

I need to dump a modified column (rpad(id, 19 ) || 'X' AS data) of a table to a
text file after that table has been updated.  I thought that a trigger might
work but I would like an external script to post process the file.  The LISTEN
and NOTIFY commands might do the job but I have no idea how to use them.  Can
someone assist me or point me in the direction of a clear 'How To' type document?

Kind Regards,
Keith

Re: automatically dump a table when it is updated

From

"Robert Wimmer"

Date:

28 February 2007, 15:16:40



>From: "Keith Worthington" <keithw@narrowpathinc.com>
>Reply-To: KeithW@narrowpathinc.com
>To: "PostgreSQL Novice" <pgsql-novice@postgresql.org>
>Subject: [NOVICE] automatically dump a table when it is updated
>Date: Tue, 27 Feb 2007 23:26:45 -0500
>
>Hi All,
>
>I need to dump a modified column (rpad(id, 19 ) || 'X' AS data) of a table
>to a
>text file after that table has been updated.  I thought that a trigger
>might
>work but I would like an external script to post process the file.  The
>LISTEN
>and NOTIFY commands might do the job but I have no idea how to use them.
>Can
>someone assist me or point me in the direction of a clear 'How To' type
>document?
>

this is a link to an example how you can use the LISTEN NOTIFY commands via
jdbc.

http://jdbc.postgresql.org/documentation/80/listennotify.html

I use this technique really often in clientprogramming - a wrote a
PostgresListener class to manage this in Java (in fact it is a package with
several classes).

regards Sepp

_________________________________________________________________
Die Vielfalt der Optionen lässt Sie im Internet erfolgreich recherchieren.
http://search.msn.at/