Обсуждение: Log full DDL alter commands to a table with an event trigger

Поиск
Список
Период
Сортировка

Log full DDL alter commands to a table with an event trigger

От
Sbob
Дата:

All;


I would like to log the full alter command for any ALTER statements to a table,  section 9.30.1 of the current docs states this:

commandpg_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.


Would there be any way to translate command to a text format and insert it into a column in a local logging table?


Thanks in advance