Re: How can a Postgres SQL script be automatically run when a new table turns up?

From: Shaozhong SHI <shishaozhong(at)gmail(dot)com>
To: Jayadevan M <maymala(dot)jayadevan(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: How can a Postgres SQL script be automatically run when a new table turns up?
Date: 2022-01-13 15:55:20
Message-ID: CA+i5JwaNXcVKpOUFSf75-ZwF7LdRbX7OMHHrFa4yX+c=gDzhMg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi, Jay,

That looks interesting. Is there an excellent example to do the following?

How to create an event trigger in Postgres? When a user finished loading a
new table on to it, the trigger can start off an script 10 minutes after
the event?

Regards,

David

On Thu, 13 Jan 2022 at 10:50, Jayadevan M <maymala(dot)jayadevan(at)gmail(dot)com>
wrote:

>
>
>
> When a user load a new table in the Postgres System? Can a script
>> automatically detect it and run?
>>
>> Are you looking for Even triggers?
> https://www.postgresql.org/docs/current/event-triggers.html
>
> Regards,
> Jay
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Laurenz Albe 2022-01-13 19:22:28 Re: Using FOREIGN TABLE to get the Size of the Actual Remote Table Behind it
Previous Message Jayadevan M 2022-01-13 10:50:24 Re: How can a Postgres SQL script be automatically run when a new table turns up?