listen/notify

Started by Tomas B. Winkleralmost 26 years ago2 messagesgeneral
Jump to latest
#1Tomas B. Winkler
tomasw@cs.huji.ac.il

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

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Tomas B. Winkler (#1)
Re: listen/notify

"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