codekingpro/portable-devtools

1<?xml version="1.0" encoding="UTF-8" standalone="no"?>2<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /><title>53.15. pg_database</title><link rel="stylesheet" type="text/css" href="stylesheet.css" /><link rev="made" href="pgsql-docs@lists.postgresql.org" /><meta name="generator" content="DocBook XSL Stylesheets Vsnapshot" /><link rel="prev" href="catalog-pg-conversion.html" title="53.14. pg_conversion" /><link rel="next" href="catalog-pg-db-role-setting.html" title="53.16. pg_db_role_setting" /></head><body id="docContent" class="container-fluid col-10"><div class="navheader"><table width="100%" summary="Navigation header"><tr><th colspan="5" align="center">53.15. <code class="structname">pg_database</code></th></tr><tr><td width="10%" align="left"><a accesskey="p" href="catalog-pg-conversion.html" title="53.14. pg_conversion">Prev</a> </td><td width="10%" align="left"><a accesskey="u" href="catalogs.html" title="Chapter 53. System Catalogs">Up</a></td><th width="60%" align="center">Chapter 53. System Catalogs</th><td width="10%" align="right"><a accesskey="h" href="index.html" title="PostgreSQL 16.3 Documentation">Home</a></td><td width="10%" align="right"> <a accesskey="n" href="catalog-pg-db-role-setting.html" title="53.16. pg_db_role_setting">Next</a></td></tr></table><hr /></div><div class="sect1" id="CATALOG-PG-DATABASE"><div class="titlepage"><div><div><h2 class="title" style="clear: both">53.15. <code class="structname">pg_database</code> <a href="#CATALOG-PG-DATABASE" class="id_link">#</a></h2></div></div></div><a id="id-1.10.4.17.2" class="indexterm"></a><p>3   The catalog <code class="structname">pg_database</code> stores information about4   the available databases.  Databases are created with the <a class="link" href="sql-createdatabase.html" title="CREATE DATABASE"><code class="command">CREATE DATABASE</code></a> command.5   Consult <a class="xref" href="managing-databases.html" title="Chapter 23. Managing Databases">Chapter 23</a> for details about the meaning6   of some of the parameters.7  </p><p>8   Unlike most system catalogs, <code class="structname">pg_database</code>9   is shared across all databases of a cluster: there is only one10   copy of <code class="structname">pg_database</code> per cluster, not11   one per database.12  </p><div class="table" id="id-1.10.4.17.5"><p class="title"><strong>Table 53.15. <code class="structname">pg_database</code> Columns</strong></p><div class="table-contents"><table class="table" summary="pg_database Columns" border="1"><colgroup><col /></colgroup><thead><tr><th class="catalog_table_entry"><p class="column_definition">13       Column Type14      </p>15      <p>16       Description17      </p></th></tr></thead><tbody><tr><td class="catalog_table_entry"><p class="column_definition">18       <code class="structfield">oid</code> <code class="type">oid</code>19      </p>20      <p>21       Row identifier22      </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">23       <code class="structfield">datname</code> <code class="type">name</code>24      </p>25      <p>26       Database name27      </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">28       <code class="structfield">datdba</code> <code class="type">oid</code>29       (references <a class="link" href="catalog-pg-authid.html" title="53.8. pg_authid"><code class="structname">pg_authid</code></a>.<code class="structfield">oid</code>)30      </p>31      <p>32       Owner of the database, usually the user who created it33      </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">34       <code class="structfield">encoding</code> <code class="type">int4</code>35      </p>36      <p>37       Character encoding for this database38       (<a class="link" href="functions-info.html#PG-ENCODING-TO-CHAR"><code class="function">pg_encoding_to_char()</code></a> can translate39       this number to the encoding name)40      </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">41       <code class="structfield">datlocprovider</code> <code class="type">char</code>42      </p>43      <p>44       Locale provider for this database: <code class="literal">c</code> = libc,45       <code class="literal">i</code> = icu46      </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">47       <code class="structfield">datistemplate</code> <code class="type">bool</code>48      </p>49      <p>50       If true, then this database can be cloned by51       any user with <code class="literal">CREATEDB</code> privileges;52       if false, then only superusers or the owner of53       the database can clone it.54      </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">55       <code class="structfield">datallowconn</code> <code class="type">bool</code>56      </p>57      <p>58       If false then no one can connect to this database.  This is59       used to protect the <code class="literal">template0</code> database from being altered.60      </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">61       <code class="structfield">datconnlimit</code> <code class="type">int4</code>62      </p>63      <p>64       Sets maximum number of concurrent connections that can be made65       to this database.  -1 means no limit, -2 indicates the database is66       invalid.67      </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">68       <code class="structfield">datfrozenxid</code> <code class="type">xid</code>69      </p>70      <p>71       All transaction IDs before this one have been replaced with a permanent72       (<span class="quote">“<span class="quote">frozen</span>”</span>) transaction ID in this database.  This is used to73       track whether the database needs to be vacuumed in order to prevent74       transaction ID wraparound or to allow <code class="literal">pg_xact</code> to be shrunk.75       It is the minimum of the per-table76       <a class="link" href="catalog-pg-class.html" title="53.11. pg_class"><code class="structname">pg_class</code></a>.<code class="structfield">relfrozenxid</code> values.77      </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">78       <code class="structfield">datminmxid</code> <code class="type">xid</code>79      </p>80      <p>81       All multixact IDs before this one have been replaced with a82       transaction ID in this database.  This is used to83       track whether the database needs to be vacuumed in order to prevent84       multixact ID wraparound or to allow <code class="literal">pg_multixact</code> to be shrunk.85       It is the minimum of the per-table86       <a class="link" href="catalog-pg-class.html" title="53.11. pg_class"><code class="structname">pg_class</code></a>.<code class="structfield">relminmxid</code> values.87      </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">88       <code class="structfield">dattablespace</code> <code class="type">oid</code>89       (references <a class="link" href="catalog-pg-tablespace.html" title="53.56. pg_tablespace"><code class="structname">pg_tablespace</code></a>.<code class="structfield">oid</code>)90      </p>91      <p>92       The default tablespace for the database.93       Within this database, all tables for which94       <a class="link" href="catalog-pg-class.html" title="53.11. pg_class"><code class="structname">pg_class</code></a>.<code class="structfield">reltablespace</code> is zero95       will be stored in this tablespace; in particular, all the non-shared96       system catalogs will be there.97      </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">98       <code class="structfield">datcollate</code> <code class="type">text</code>99      </p>100      <p>101       LC_COLLATE for this database102      </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">103       <code class="structfield">datctype</code> <code class="type">text</code>104      </p>105      <p>106       LC_CTYPE for this database107      </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">108       <code class="structfield">daticulocale</code> <code class="type">text</code>109      </p>110      <p>111       ICU locale ID for this database112      </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">113       <code class="structfield">daticurules</code> <code class="type">text</code>114      </p>115      <p>116       ICU collation rules for this database117      </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">118       <code class="structfield">datcollversion</code> <code class="type">text</code>119      </p>120      <p>121       Provider-specific version of the collation.  This is recorded when the122       database is created and then checked when it is used, to detect123       changes in the collation definition that could lead to data corruption.124      </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">125       <code class="structfield">datacl</code> <code class="type">aclitem[]</code>126      </p>127      <p>128       Access privileges; see <a class="xref" href="ddl-priv.html" title="5.7. Privileges">Section 5.7</a> for details129      </p></td></tr></tbody></table></div></div><br class="table-break" /></div><div class="navfooter"><hr /><table width="100%" summary="Navigation footer"><tr><td width="40%" align="left"><a accesskey="p" href="catalog-pg-conversion.html" title="53.14. pg_conversion">Prev</a> </td><td width="20%" align="center"><a accesskey="u" href="catalogs.html" title="Chapter 53. System Catalogs">Up</a></td><td width="40%" align="right"> <a accesskey="n" href="catalog-pg-db-role-setting.html" title="53.16. pg_db_role_setting">Next</a></td></tr><tr><td width="40%" align="left" valign="top">53.14. <code class="structname">pg_conversion</code> </td><td width="20%" align="center"><a accesskey="h" href="index.html" title="PostgreSQL 16.3 Documentation">Home</a></td><td width="40%" align="right" valign="top"> 53.16. <code class="structname">pg_db_role_setting</code></td></tr></table></div></body></html>