Skip site navigation (1) Skip section navigation (2)

Re: automatically dump a table when it is updated

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 (view raw or flat)
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/


In response to

pgsql-novice by date

Next:From: Tom LaneDate: 2007-02-28 17:15:30
Subject: Re: pq_flush: send() failed: Broken pipe
Previous:From: Richard Broersma JrDate: 2007-02-28 14:52:07
Subject: Re: Crappy performance even though not swapping

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group