Postgres Pro
Downloads
Home   >   mailing lists

Re: Is there a way to be notified on the CREATE TABLE execution? - Mailing list pgsql-general

From Pierre Timmermans
Subject Re: Is there a way to be notified on the CREATE TABLE execution?
Date
Msg-id 2025368780.2391793.1529481055460@mail.yahoo.com
Whole thread Raw
In response to Is there a way to be notified on the CREATE TABLE execution?  (Igor Korot <ikorot01@gmail.com>)
List pgsql-general
Tree view
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 by date:

Previous
From: Łukasz Jarych
Date:
Subject: Re: Run Stored procedure - function from VBA
Next
From: Pierre Timmermans
Date:
Subject: Re: using pg_basebackup for point in time recovery