Request a Demo
Home   >   mailing lists

Log full DDL alter commands to a table with an event trigger - Mailing list pgsql-admin

From Sbob
Subject Log full DDL alter commands to a table with an event trigger
Date
Msg-id 8af0a6d2-663d-413d-9463-8225500dbbf5@quadratum-braccas.com
Whole thread Raw
List pgsql-admin
Tree view

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 by date:

Previous
From: "Day, Joseph"
Date:
Subject: Re: Need an idea to operate massive delete operation on big size table.
Next
From: Rajesh Kumar
Date:
Subject: Move datapath