Postgres Pro
Downloads
Home   >   mailing lists

Event Triggers unable to capture the DDL script executed - Mailing list pgsql-general

From Neethu P
Subject Event Triggers unable to capture the DDL script executed
Date
Msg-id BN6PR12MB17799C4D94EC259180F8EB69D1AA9@BN6PR12MB1779.namprd12.prod.outlook.com
Whole thread Raw
Responses Re: Event Triggers unable to capture the DDL script executed  (Laurenz Albe <laurenz.albe@cybertec.at>)
List pgsql-general
Tree view
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_commandA 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

pgsql-general by date:

Previous
From: Tom Dunstan
Date:
Subject: Re: RLS without leakproof restrictions?
Next
From: HECTOR INGERTO
Date:
Subject: PostgreSQL optimizations for CoW FS