From: | "Robert Wimmer" <seppwimmer(at)hotmail(dot)com> |
---|---|
To: | KeithW(at)narrowpathinc(dot)com, pgsql-novice(at)postgresql(dot)org |
Subject: | Re: automatically dump a table when it is updated |
Date: | 2007-02-28 16:16:08 |
Message-ID: | BAY122-F363FC515C5685439D6FBDAD0810@phx.gbl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
>From: "Keith Worthington" <keithw(at)narrowpathinc(dot)com>
>Reply-To: KeithW(at)narrowpathinc(dot)com
>To: "PostgreSQL Novice" <pgsql-novice(at)postgresql(dot)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/
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2007-02-28 17:15:30 | Re: pq_flush: send() failed: Broken pipe |
Previous Message | Richard Broersma Jr | 2007-02-28 14:52:07 | Re: Crappy performance even though not swapping |