postgres ddl schema evolution - ghdrako/doc_snipets GitHub Wiki

• https://www.postgresql.org/docs/current/functions-event-triggers.html
• https://github.com/striim/doc-downloads/blob/main/pg_ddl_setup_410.sql
• https://stackoverflow.com/questions/68770821/pg-event-trigger-ddl-commands-with-drop-table-command
• https://www.striim.com/docs/en/postgresql-cdc.html#postgresql-setup-for-schema-evolution
• https://github.com/ghdrako/doc_snipets/wiki/postgres-event-trigger

CREATE EVENT TRIGGER pg_get_ddl_command on ddl_command_end EXECUTE PROCEDURE ddl_capture_command();
CREATE EVENT TRIGGER pg_get_ddl_drop on sql_drop EXECUTE PROCEDURE ddl_capture_command();