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

Sbob <sbob@xxxxxxxxxxxxxxxxxxxxx> · Wed, 15 Jan 2025 11:41:36 -0700



    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