How to watch for schema changes

From: Igor Korot <ikorot01(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: How to watch for schema changes
Date: 2018-07-03 17:21:50
Message-ID: CA+FnnTxqScf6mDw_7HLMfu7YTagPrsYUw-bc=OKsBQ0TqprvEA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi, ALL,
Is there any trigger or some other means I can do on the server
which will watch for CREATE/ALTER/DROP TABLE command and after successful
execution of those will issue a NOTIFY statement?

Thank you.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2018-07-03 17:32:53 Re: How to watch for schema changes
Previous Message Mathieu PUJOL 2018-07-03 15:35:17 Re: Analyze plan of foreign data wrapper