Home Explore Blog CI



postgresql

22th chunk of `doc/src/sgml/information_schema.sgml`
b95c13f89fc3da5ca8f141878557cde37568126bd1a6774c0000000100000fa3
 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> <type>sql_identifier</type>
      </para>
      <para>
       An identifier of the data type descriptor of the column, unique
       among the data type descriptors pertaining to the table.  This
       is mainly useful for joining with other instances of such
       identifiers.  (The specific format of the identifier is not
       defined and not guaranteed to remain the same in future
       versions.)
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>is_self_referencing</structfield> <type>yes_or_no</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>is_identity</structfield> <type>yes_or_no</type>
      </para>
      <para>
       If the column is an identity column, then <literal>YES</literal>,
       else <literal>NO</literal>.
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>identity_generation</structfield> <type>character_data</type>
      </para>
      <para>
       If the column is an identity column, then <literal>ALWAYS</literal>
       or <literal>BY DEFAULT</literal>, reflecting the definition of the
       column.
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>identity_start</structfield> <type>character_data</type>
      </para>
      <para>
       If the column is an identity column, then the start value of the
       internal sequence, else null.
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>identity_increment</structfield> <type>character_data</type>
      </para>
      <para>
       If the column is an identity column, then the increment of the internal
       sequence, else null.
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>identity_maximum</structfield> <type>character_data</type>
      </para>
      <para>
       If the column is an identity column, then the maximum value of the
       internal sequence, else null.
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>identity_minimum</structfield> <type>character_data</type>
      </para>
      <para>
       If the column is an identity column, then the minimum value of the
       internal sequence, else null.
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>identity_cycle</structfield> <type>yes_or_no</type>
      </para>
      <para>

Title: Column Metadata for Identity Columns and Other Features
Summary
This section describes metadata columns for identity columns, including details about the column's identity generation, sequence start and increment values, and minimum and maximum values, as well as other features such as data type descriptors and self-referencing columns, with many fields providing specific details about the column's properties.