Home • Explore • Blog • CI
☰



postgresql
80th chunk of `doc/src/sgml/information_schema.sgml`
e0330848d1d29cee9a205d5a99ecb7139079be6cf61aefa40000000100000fa2
 <type>sql_identifier</type>
      </para>
      <para>
       Name of the type the transform is for
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>specific_catalog</structfield> <type>sql_identifier</type>
      </para>
      <para>
       Name of the database containing the function (always the current database)
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>specific_schema</structfield> <type>sql_identifier</type>
      </para>
      <para>
       Name of the schema containing the function
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>specific_name</structfield> <type>sql_identifier</type>
      </para>
      <para>
       The <quote>specific name</quote> of the function.  See <xref linkend="infoschema-routines"/> for more information.
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>group_name</structfield> <type>sql_identifier</type>
      </para>
      <para>
       The SQL standard allows defining transforms in <quote>groups</quote>,
       and selecting a group at run time.  PostgreSQL does not support this.
       Instead, transforms are specific to a language.  As a compromise, this
       field contains the language the transform is for.
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>transform_type</structfield> <type>character_data</type>
      </para>
      <para>
       <literal>FROM SQL</literal> or <literal>TO SQL</literal>
      </para></entry>
     </row>
    </tbody>
   </tgroup>
  </table>
 </sect1>

 <sect1 id="infoschema-triggered-update-columns">
  <title><literal>triggered_update_columns</literal></title>

  <para>
   For triggers in the current database that specify a column list
   (like <literal>UPDATE OF column1, column2</literal>), the
   view <literal>triggered_update_columns</literal> identifies these
   columns.  Triggers that do not specify a column list are not
   included in this view.  Only those columns are shown that the
   current user owns or has some privilege other than
   <literal>SELECT</literal> on.
  </para>

  <table>
   <title><structname>triggered_update_columns</structname> Columns</title>
   <tgroup cols="1">
    <thead>
     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       Column Type
      </para>
      <para>
       Description
      </para></entry>
     </row>
    </thead>

    <tbody>
     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>trigger_catalog</structfield> <type>sql_identifier</type>
      </para>
      <para>
       Name of the database that contains the trigger (always the current database)
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>trigger_schema</structfield> <type>sql_identifier</type>
      </para>
      <para>
       Name of the 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_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
Title: Information Schema: Transforms and Triggered Update Columns
Summary
This section describes two views in the information schema: transforms and triggered_update_columns. The transforms view contains information about the transforms defined in the current database, including columns for the type, function, and language. The triggered_update_columns view identifies columns for triggers that specify a column list, showing only columns that the current user owns or has some privilege on.