You could do that by logging DDL as suggested, and monitoring the log. You could also use event triggers: https://www.postgresql.org/docs/current/static/event-triggers.html -- Scott Ribe scott_ribe@xxxxxxxxxxxxxxxx https://www.linkedin.com/in/scottribe/ > On Aug 28, 2018, at 2:53 AM, pavan95 <pavan.postgresdba@xxxxxxxxx> wrote: > > So looking for a any table structure modifications(mainly alter DDL) if > changed in a publisher I need to receive an alert(through any custom script > or via a mail).
