Re: Is there a way to be notified on the CREATE TABLE execution?

Поиск
Список
Период
Сортировка
От Pierre Timmermans
Тема Re: Is there a way to be notified on the CREATE TABLE execution?
Дата
Msg-id 2025368780.2391793.1529481055460@mail.yahoo.com
обсуждение исходный текст
Ответ на Is there a way to be notified on the CREATE TABLE execution?  (Igor Korot <ikorot01@gmail.com>)
Список pgsql-general
I believe you could use an event trigger in postgres to capture the fact that a table was created: https://www.postgresql.org/docs/current/static/event-triggers.html

In the trigger you would then have to code whatever is needed to notify the external software (via a REST call or by posting something in a messaging bus, ...)


Regards, Pierre


On Wednesday, June 20, 2018, 12:08:48 AM GMT+2, 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 presume this is a DBMS-specific...

Thank you.

В списке pgsql-general по дате отправления:

Предыдущее
От: Łukasz Jarych
Дата:
Сообщение: Re: Run Stored procedure - function from VBA
Следующее
От: Pierre Timmermans
Дата:
Сообщение: Re: using pg_basebackup for point in time recovery