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

public inbox for [email protected]  
help / color / mirror / Atom feed

From: Sbob <[email protected]>
To: [email protected]
Subject: Log full DDL alter commands to a table with an event trigger
Date: Wed, 15 Jan 2025 11:41:36 -0700
Message-ID: <[email protected]> (raw)

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:

|command| 	|pg_ddl_command| 	A 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

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: Log full DDL alter commands to a table with an event trigger
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox