Home Explore Blog CI



postgresql

79th chunk of `doc/src/sgml/information_schema.sgml`
9591101d494ad01f632bae38c0068d201ed382999ff2c3450000000100000fa3
 <structfield>user_defined_type_schema</structfield> <type>sql_identifier</type>
      </para>
      <para>
       If the table is a typed table, the name of the schema that
       contains the underlying data type, else null.
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>user_defined_type_name</structfield> <type>sql_identifier</type>
      </para>
      <para>
       If the table is a typed table, the name of the underlying data
       type, else null.
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>is_insertable_into</structfield> <type>yes_or_no</type>
      </para>
      <para>
       <literal>YES</literal> if the table is insertable into,
       <literal>NO</literal> if not (Base tables are always insertable
       into, views not necessarily.)
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>is_typed</structfield> <type>yes_or_no</type>
      </para>
      <para>
       <literal>YES</literal> if the table is a typed table, <literal>NO</literal> if not
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>commit_action</structfield> <type>character_data</type>
      </para>
      <para>
       Not yet implemented
      </para></entry>
     </row>
    </tbody>
   </tgroup>
  </table>
 </sect1>

 <sect1 id="infoschema-transforms">
  <title><literal>transforms</literal></title>

  <para>
   The view <literal>transforms</literal> contains information about the
   transforms defined in the current database.  More precisely, it contains a
   row for each function contained in a transform (the <quote>from SQL</quote>
   or <quote>to SQL</quote> function).
  </para>

  <table>
   <title><structname>transforms</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>udt_catalog</structfield> <type>sql_identifier</type>
      </para>
      <para>
       Name of the database that contains the type the transform is for (always the current database)
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>udt_schema</structfield> <type>sql_identifier</type>
      </para>
      <para>
       Name of the schema that contains the type the transform is for
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>udt_name</structfield> <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

Title: Information Schema: Transforms View
Summary
This section describes the transforms view in the information schema, which contains information about the transforms defined in the current database, including columns for the type the transform is for, the database and schema containing the type and the function, and the specific name of the function, providing details about each function contained in a transform.