Postgres Pro
Downloads
Home   >   mailing lists

Re: How can a Postgres SQL script be automatically run when a new table turns up? - Mailing list pgsql-general

From Shaozhong SHI
Subject Re: How can a Postgres SQL script be automatically run when a new table turns up?
Date
Msg-id CA+i5JwaNXcVKpOUFSf75-ZwF7LdRbX7OMHHrFa4yX+c=gDzhMg@mail.gmail.com
Whole thread Raw
In response to Re: How can a Postgres SQL script be automatically run when a new table turns up?  (Jayadevan M <maymala.jayadevan@gmail.com>)
Responses Re: How can a Postgres SQL script be automatically run when a new table turns up?  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
Tree view
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.jayadevan@gmail.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?

Regards,
Jay 

pgsql-general by date:

Previous
From: Jayadevan M
Date:
Subject: Re: How can a Postgres SQL script be automatically run when a new table turns up?
Next
From: Laurenz Albe
Date:
Subject: Re: Using FOREIGN TABLE to get the Size of the Actual Remote Table Behind it