Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
automatically dump a table when it is updated
- From: "Keith Worthington" <keithw(at)narrowpathinc(dot)com>
- To: "PostgreSQL Novice" <pgsql-novice(at)postgresql(dot)org>
- Subject: 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? Kind Regards, Keith
- Follow-Ups:
- Re: automatically dump a table when it is updated
- From: Robert Wimmer
- Re: automatically dump a table when it is updated
- Prev by Date: Re: Crappy performance even though not swapping
- Next by Date: Re: pq_flush: send() failed: Broken pipe
- Previous by thread: Crappy performance even though not swapping
- Next by thread: Re: automatically dump a table when it is updated
- Indexes: