Home Explore Blog CI



postgresql

13th chunk of `doc/src/sgml/information_schema.sgml`
cfb0b9890643c486f7404f71524d827b154e40dfb1ea59ca0000000100000fa4

     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>collation_name</structfield> <type>sql_identifier</type>
      </para>
      <para>
       Name of the default collation
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>character_set_catalog</structfield> <type>sql_identifier</type>
      </para>
      <para>
       Character sets are currently not implemented as schema objects, so this column is null
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>character_set_schema</structfield> <type>sql_identifier</type>
      </para>
      <para>
       Character sets are currently not implemented as schema objects, so this column is null
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>character_set_name</structfield> <type>sql_identifier</type>
      </para>
      <para>
       Name of the character set
      </para></entry>
     </row>
    </tbody>
   </tgroup>
  </table>
 </sect1>

 <sect1 id="infoschema-column-column-usage">
  <title><literal>column_column_usage</literal></title>

  <para>
   The view <literal>column_column_usage</literal> identifies all generated
   columns that depend on another base column in the same table.  Only tables
   owned by a currently enabled role are included.
  </para>

  <table>
   <title><structname>column_column_usage</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>table_catalog</structfield> <type>sql_identifier</type>
      </para>
      <para>
       Name of the database containing the table (always the current database)
      </para></entry>
     </row>

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

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

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>column_name</structfield> <type>sql_identifier</type>
      </para>
      <para>
       Name of the base column that a generated column depends on
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>dependent_column</structfield> <type>sql_identifier</type>
      </para>
      <para>
       Name of the generated column
      </para></entry>
     </row>
    </tbody>
   </tgroup>
  </table>
 </sect1>

 <sect1 id="infoschema-column-domain-usage">
  <title><literal>column_domain_usage</literal></title>

  <para>
   The view <literal>column_domain_usage</literal> identifies all
   columns (of a table or a view) that make use of some domain defined
   in the current database and owned by a currently enabled role.
  </para>

  <table>
   <title><structname>column_domain_usage</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">

Title: Information Schema Views for Column Usage and Domain Usage
Summary
This section describes several Information Schema views, including column_column_usage, which identifies generated columns that depend on another base column, and column_domain_usage, which identifies columns that make use of a domain defined in the current database, with details on the columns and descriptions of each view.