Re: listen/notify - Mailing list pgsql-general

From Tom Lane
Subject Re: listen/notify
Date
Msg-id 24211.963425347@sss.pgh.pa.us
Whole thread Raw
In response to listen/notify  ("Tomas B. Winkler" <tomasw@cs.huji.ac.il>)
List pgsql-general
"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

pgsql-general by date:

Previous
From: The Hermit Hacker
Date:
Subject: Re: Sorry...
Next
From: "J.R. Belding"
Date:
Subject: Re: psql and Gnu readline