Hi team,
We are using event triggers to capture the DDL changes in a postgres database. However, we are unable to get the column information & the actual DDL script executed, while a table is altered.
Also, in the postgres documentation for pg_event_trigger_ddl_commands ()- it is mentioned as below.
pg_ddl_command A complete representation of the command, in internal format. This cannot be output directly, but it can be passed to other functions to obtain different pieces of information about the command.
Is it possible to access pg_ddl_command in postgresql? Or is there any scripts which can help to get the actual Alter DDL statement that was executed by the user?
Thanks & Regards,
Neethu