Home > mailing lists

automatically dump a table when it is updated - Mailing list pgsql-novice

From	Keith Worthington
Subject	automatically dump a table when it is updated
Date	February 28, 2007 03:32:22
Msg-id	20070228040847.M53466@narrowpathinc.com Whole thread Raw
Responses	Re: automatically dump a table when it is updated ("Robert Wimmer" <seppwimmer@hotmail.com>)
List	pgsql-novice

Tree view

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

pgsql-novice by date:

From: "Phillip Smith"
Date: 28 February 2007, 02:24:51
Subject: Re: Crappy performance even though not swapping

From: Yumiko Izumi
Date: 28 February 2007, 07:24:13
Subject: Re: pq_flush: send() failed: Broken pipe

automatically dump a table when it is updated - Mailing list pgsql-novice

Previous

Next