Event Triggers unable to capture the DDL script executed

Поиск
Список
Период
Сортировка
От Neethu P
Тема Event Triggers unable to capture the DDL script executed
Дата
Msg-id BN6PR12MB17799C4D94EC259180F8EB69D1AA9@BN6PR12MB1779.namprd12.prod.outlook.com
обсуждение исходный текст
Ответы Re: Event Triggers unable to capture the DDL script executed  (Laurenz Albe <laurenz.albe@cybertec.at>)
Список pgsql-general
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 по дате отправления:

Предыдущее
От: Tom Dunstan
Дата:
Сообщение: Re: RLS without leakproof restrictions?
Следующее
От: HECTOR INGERTO
Дата:
Сообщение: PostgreSQL optimizations for CoW FS