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

Поиск
Список
Период
Сортировка
От Sbob
Тема Log full DDL alter commands to a table with an event trigger
Дата
Msg-id 8af0a6d2-663d-413d-9463-8225500dbbf5@quadratum-braccas.com
обсуждение исходный текст
Список pgsql-admin

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

В списке pgsql-admin по дате отправления: