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: 2007-02-28 04:26:45
Message-ID: 20070228040847.M53466@narrowpathinc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Yumiko Izumi 2007-02-28 08:24:42 Re: pq_flush: send() failed: Broken pipe
Previous Message Phillip Smith 2007-02-28 03:24:38 Re: Crappy performance even though not swapping