automatically dump a table when it is updated

Поиск
Список
Период
Сортировка
От Keith Worthington
Тема automatically dump a table when it is updated
Дата
Msg-id 20070228040847.M53466@narrowpathinc.com
обсуждение исходный текст
Ответы Re: automatically dump a table when it is updated  ("Robert Wimmer" <seppwimmer@hotmail.com>)
Список 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

В списке pgsql-novice по дате отправления:

Предыдущее
От: "Phillip Smith"
Дата:
Сообщение: Re: Crappy performance even though not swapping
Следующее
От: Yumiko Izumi
Дата:
Сообщение: Re: pq_flush: send() failed: Broken pipe