Re: Is there a way to be notified on the CREATE TABLE execution? - Mailing list pgsql-general

From Igor Korot
Subject Re: Is there a way to be notified on the CREATE TABLE execution?
Date
Msg-id CA+FnnTy_=KNetdpxVn8APQw_3xpTxPq8nAe3FNdwD5-_KUBBpg@mail.gmail.com
Whole thread Raw
In response to Re: Is there a way to be notified on the CREATE TABLE execution?  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: Is there a way to be notified on the CREATE TABLE execution?  (Francisco Olarte <folarte@peoplecall.com>)
List pgsql-general
Hi, David,

On Tue, Jun 19, 2018 at 5:13 PM, David G. Johnston
<david.g.johnston@gmail.com> wrote:
> On Tuesday, June 19, 2018, Igor Korot <ikorot01@gmail.com> 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.
>
>
>


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: tsvector field length limitation
Next
From: Jonathan Marks
Date:
Subject: Re: tsvector field length limitation