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

Поиск
Список
Период
Сортировка
От Shaozhong SHI
Тема Re: How can a Postgres SQL script be automatically run when a new table turns up?
Дата
Msg-id CA+i5JwaNXcVKpOUFSf75-ZwF7LdRbX7OMHHrFa4yX+c=gDzhMg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: How can a Postgres SQL script be automatically run when a new table turns up?  (Jayadevan M <maymala.jayadevan@gmail.com>)
Ответы Re: How can a Postgres SQL script be automatically run when a new table turns up?
Список 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.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 по дате отправления:

Предыдущее
От: Jayadevan M
Дата:
Сообщение: Re: How can a Postgres SQL script be automatically run when a new table turns up?
Следующее
От: Laurenz Albe
Дата:
Сообщение: Re: Using FOREIGN TABLE to get the Size of the Actual Remote Table Behind it