Home Explore Blog CI



postgresql

21th chunk of `doc/src/sgml/information_schema.sgml`
36952180010d1bd093543ba74274e6a9770535afcfcbace50000000100000fbe
 <structfield>collation_schema</structfield> <type>sql_identifier</type>
      </para>
      <para>
       Name of the schema containing the collation of the column, null
       if default or the data type of the column is not collatable
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>collation_name</structfield> <type>sql_identifier</type>
      </para>
      <para>
       Name of the collation of the column, null if default or the
       data type of the column is not collatable
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>domain_catalog</structfield> <type>sql_identifier</type>
      </para>
      <para>
       If the column has a domain type, the name of the database that
       the domain is defined in (always the current database), else
       null.
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>domain_schema</structfield> <type>sql_identifier</type>
      </para>
      <para>
       If the column has a domain type, the name of the schema that
       the domain is defined in, else null.
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>domain_name</structfield> <type>sql_identifier</type>
      </para>
      <para>
       If the column has a domain type, the name of the domain, else null.
      </para></entry>
     </row>

     <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 the column data type (the underlying
       type of the domain, if applicable) is defined in (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 the column data type (the underlying
       type of the domain, if applicable) is defined in
      </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 column data type (the underlying type of the
       domain, if applicable)
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>scope_catalog</structfield> <type>sql_identifier</type>
      </para>
      <para>
       Applies to a feature not available in <productname>PostgreSQL</productname>
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>scope_schema</structfield> <type>sql_identifier</type>
      </para>
      <para>
       Applies to a feature not available in <productname>PostgreSQL</productname>
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>scope_name</structfield> <type>sql_identifier</type>
      </para>
      <para>
       Applies to a feature not available in <productname>PostgreSQL</productname>
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>maximum_cardinality</structfield> <type>cardinal_number</type>
      </para>
      <para>
       Always null, because arrays always have unlimited maximum cardinality in <productname>PostgreSQL</productname>
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>dtd_identifier</structfield>

Title: Column Metadata for Domains, UDTs, and Other Features
Summary
This section describes metadata columns for domains, user-defined types (UDTs), and other features, including catalog, schema, and name information, with many fields providing specific details about the column's data type and applicable domains, but some fields are not applicable or always null in PostgreSQL.