postgres ddl schema evolution
ghdrako edited this page Apr 29, 2024
·
6 revisions
- 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();
Test