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