Home Explore Blog CI



postgresql

82th chunk of `doc/src/sgml/information_schema.sgml`
95493f21aeb6263bf6295a02c6b1a484750766adb3bbef150000000100000fba
 schema that contains the trigger
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>trigger_name</structfield> <type>sql_identifier</type>
      </para>
      <para>
       Name of the trigger
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>event_manipulation</structfield> <type>character_data</type>
      </para>
      <para>
       Event that fires the trigger (<literal>INSERT</literal>,
       <literal>UPDATE</literal>, or <literal>DELETE</literal>)
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>event_object_catalog</structfield> <type>sql_identifier</type>
      </para>
      <para>
       Name of the database that contains the table that the trigger
       is defined on (always the current database)
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>event_object_schema</structfield> <type>sql_identifier</type>
      </para>
      <para>
       Name of the schema that contains the table that the trigger is defined on
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>event_object_table</structfield> <type>sql_identifier</type>
      </para>
      <para>
       Name of the table that the trigger is defined on
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>action_order</structfield> <type>cardinal_number</type>
      </para>
      <para>
       Firing order among triggers on the same table having the same
       <literal>event_manipulation</literal>,
       <literal>action_timing</literal>, and
       <literal>action_orientation</literal>.  In
       <productname>PostgreSQL</productname>, triggers are fired in name
       order, so this column reflects that.
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>action_condition</structfield> <type>character_data</type>
      </para>
      <para>
       <literal>WHEN</literal> condition of the trigger, null if none
       (also null if the table is not owned by a currently enabled
       role)
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>action_statement</structfield> <type>character_data</type>
      </para>
      <para>
       Statement that is executed by the trigger (currently always
       <literal>EXECUTE FUNCTION
       <replaceable>function</replaceable>(...)</literal>)
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>action_orientation</structfield> <type>character_data</type>
      </para>
      <para>
       Identifies whether the trigger fires once for each processed
       row or once for each statement (<literal>ROW</literal> or
       <literal>STATEMENT</literal>)
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>action_timing</structfield> <type>character_data</type>
      </para>
      <para>
       Time at which the trigger fires (<literal>BEFORE</literal>,
       <literal>AFTER</literal>, or <literal>INSTEAD OF</literal>)
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>action_reference_old_table</structfield> <type>sql_identifier</type>
      </para>
      <para>
       Name of the <quote>old</quote> transition table, or null if none
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para

Title: Triggers View Columns
Summary
This section describes the columns in the triggers view, which contains information about triggers in the current database, including the trigger name, event manipulation, event object details, action order, condition, statement, orientation, timing, and reference to old tables.