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

Reply via email to