Hi, David, On Tue, Jun 19, 2018 at 5:13 PM, David G. Johnston <david.g.johnston@xxxxxxxxx> wrote: > On Tuesday, June 19, 2018, Igor Korot <ikorot01@xxxxxxxxx> wrote: >> >> Hi, ALL, >> Consider a scenario: >> >> 1. A software that uses libpq is executing. >> 2. Someone opens up a terminal and creates a table. >> 3. A software needs to know about this new table. > > > I'd start here: > > https://www.postgresql.org/docs/10/static/sql-createeventtrigger.html > > Your scenario suggests you may wish to avail yourself of the Listen and > Notify commands as well. I did look at the Listen/Notify. Unfortunately the listening is done on the channel versus listening for the specific event. I also looked at the https://www.postgresql.org/docs/9.1/static/libpq-example.html#LIBPQ-EXAMPLE-2, but am not sure how to create an appropriate event. Thank you. > > David J. > > >
