Thread: listen/notify

listen/notify

From
"Tomas B. Winkler"
Date:
Hi
Could someone, please give me a little example on how to use listen/notify
mechanism. Or at least point me to some more legible documentation.
What I particulary need is that my frontend application is notified on
update/insert in a table.
Thanx a lot.

Tomas Winkler
The System Group
CSE HUJI


Re: listen/notify

From
Tom Lane
Date:
"Tomas B. Winkler" <tomasw@cs.huji.ac.il> writes:
> Could someone, please give me a little example on how to use listen/notify
> mechanism. Or at least point me to some more legible documentation.
> What I particulary need is that my frontend application is notified on
> update/insert in a table.

Make an ON INSERT OR UPDATE trigger that executes the NOTIFY.

            regards, tom lane