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

[Shaozhong SHI <shishaozhong@xxxxxxxxx>]

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@xxxxxxxxx> 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