Home Explore Blog CI



postgresql

37th chunk of `doc/src/sgml/catalogs.sgml`
ecd627c7701e992afacf854c23d712d4619ab21f871c76b50000000100000fa1
 role="column_definition">
       <structfield>datname</structfield> <type>name</type>
      </para>
      <para>
       Database name
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>datdba</structfield> <type>oid</type>
       (references <link linkend="catalog-pg-authid"><structname>pg_authid</structname></link>.<structfield>oid</structfield>)
      </para>
      <para>
       Owner of the database, usually the user who created it
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>encoding</structfield> <type>int4</type>
      </para>
      <para>
       Character encoding for this database
       (<link linkend="pg-encoding-to-char"><function>pg_encoding_to_char()</function></link> can translate
       this number to the encoding name)
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>datlocprovider</structfield> <type>char</type>
      </para>
      <para>
       Locale provider for this database: <literal>b</literal> = builtin,
       <literal>c</literal> = libc, <literal>i</literal> = icu </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>datistemplate</structfield> <type>bool</type>
      </para>
      <para>
       If true, then this database can be cloned by
       any user with <literal>CREATEDB</literal> privileges;
       if false, then only superusers or the owner of
       the database can clone it.
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>datallowconn</structfield> <type>bool</type>
      </para>
      <para>
       If false then no one can connect to this database.  This is
       used to protect the <literal>template0</literal> database from being altered.
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>dathasloginevt</structfield> <type>bool</type>
      </para>
      <para>
        Indicates that there are login event triggers defined for this database.
        This flag is used to avoid extra lookups on the
        <structname>pg_event_trigger</structname> table during each backend
        startup.  This flag is used internally by <productname>PostgreSQL</productname>
        and should not be manually altered or read for monitoring purposes.
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>datconnlimit</structfield> <type>int4</type>
      </para>
      <para>
       Sets maximum number of concurrent connections that can be made
       to this database.  -1 means no limit, -2 indicates the database is
       invalid.
      </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

Title: pg_database Catalog Columns (Continued)
Summary
This section describes the remaining columns of the pg_database catalog, including datlocprovider (locale provider), datistemplate (whether it can be cloned), datallowconn (whether connections are allowed), dathasloginevt (indicates login event triggers), datconnlimit (maximum concurrent connections), datfrozenxid (oldest transaction ID), and datminmxid (oldest multi-transaction ID).