Home • Explore • Blog • CI
☰



postgresql
12th chunk of `doc/src/sgml/information_schema.sgml`
9e7f6e1121c8c9dbeed8457311384116012c366eb32cac490000000100000fa7
 database.
  </para>

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

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>collation_schema</structfield> <type>sql_identifier</type>
      </para>
      <para>
       Name of the schema containing the collation
      </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 default collation
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>pad_attribute</structfield> <type>character_data</type>
      </para>
      <para>
       Always <literal>NO PAD</literal> (The alternative <literal>PAD
       SPACE</literal> is not supported by PostgreSQL.)
      </para></entry>
     </row>
    </tbody>
   </tgroup>
  </table>
 </sect1>

 <sect1 id="infoschema-collation-character-set-applicab"> <!-- max 44 characters -->
  <title><literal>collation_character_set_&zwsp;applicability</literal></title>

  <para>
   The view <literal>collation_character_set_applicability</literal>
   identifies which character set the available collations are
   applicable to.  In PostgreSQL, there is only one character set per
   database (see explanation
   in <xref linkend="infoschema-character-sets"/>), so this view does
   not provide much useful information.
  </para>

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

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>collation_schema</structfield> <type>sql_identifier</type>
      </para>
      <para>
       Name of the schema containing the collation
      </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 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">
Title: Collation and Character Set Applicability
Summary
This section describes the Information Schema views related to collations and character set applicability, including the collations view, which lists available collations, and the collation_character_set_applicability view, which identifies the character sets that available collations are applicable to, with details on the columns and descriptions of each view.