Home Explore Blog CI



postgresql

38th chunk of `doc/src/sgml/catalogs.sgml`
ffb0baa876559c09d4d3c5071081ea42af507e96a9e79bed0000000100000fa5

      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>datfrozenxid</structfield> <type>xid</type>
      </para>
      <para>
       All transaction IDs before this one have been replaced with a permanent
       (<quote>frozen</quote>) transaction ID in this database.  This is used to
       track whether the database needs to be vacuumed in order to prevent
       transaction ID wraparound or to allow <literal>pg_xact</literal> to be shrunk.
       It is the minimum of the per-table
       <link linkend="catalog-pg-class"><structname>pg_class</structname></link>.<structfield>relfrozenxid</structfield> values.
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>datminmxid</structfield> <type>xid</type>
      </para>
      <para>
       All multixact IDs before this one have been replaced with a
       transaction ID in this database.  This is used to
       track whether the database needs to be vacuumed in order to prevent
       multixact ID wraparound or to allow <literal>pg_multixact</literal> to be shrunk.
       It is the minimum of the per-table
       <link linkend="catalog-pg-class"><structname>pg_class</structname></link>.<structfield>relminmxid</structfield> values.
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>dattablespace</structfield> <type>oid</type>
       (references <link linkend="catalog-pg-tablespace"><structname>pg_tablespace</structname></link>.<structfield>oid</structfield>)
      </para>
      <para>
       The default tablespace for the database.
       Within this database, all tables for which
       <link linkend="catalog-pg-class"><structname>pg_class</structname></link>.<structfield>reltablespace</structfield> is zero
       will be stored in this tablespace; in particular, all the non-shared
       system catalogs will be there.
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>datcollate</structfield> <type>text</type>
      </para>
      <para>
       LC_COLLATE for this database
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>datctype</structfield> <type>text</type>
      </para>
      <para>
       LC_CTYPE for this database
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>datlocale</structfield> <type>text</type>
      </para>
      <para>
       Collation provider locale name for this database. If the
       provider is <literal>libc</literal>,
       <structfield>datlocale</structfield> is <literal>NULL</literal>;
       <structfield>datcollate</structfield> and
       <structfield>datctype</structfield> are used instead.
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>daticurules</structfield> <type>text</type>
      </para>
      <para>
       ICU collation rules for this database
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>datcollversion</structfield> <type>text</type>
      </para>
      <para>
       Provider-specific version of the collation.  This is recorded when the
       database is created and then checked when it is used, to detect
       changes in the collation definition that could lead to data corruption.
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>datacl</structfield> <type>aclitem[]</type>
      </para>
      <para>
       Access privileges; see <xref linkend="ddl-priv"/> for details

Title: pg_database Catalog Columns (Continued)
Summary
This section describes more columns of the pg_database catalog. It includes datfrozenxid (oldest transaction ID), datminmxid (oldest multi-transaction ID), dattablespace (default tablespace), datcollate (LC_COLLATE), datctype (LC_CTYPE), datlocale (collation provider locale name), daticurules (ICU collation rules), datcollversion (collation version), and datacl (access privileges).