blob: 6d50758aadf94d902f059244cc87deb41aca6efd (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
|
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<!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 15.7 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></h2></div></div></div><a id="id-1.10.4.17.2" class="indexterm"></a><p>
The catalog <code class="structname">pg_database</code> stores information about
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.
Consult <a class="xref" href="managing-databases.html" title="Chapter 23. Managing Databases">Chapter 23</a> for details about the meaning
of some of the parameters.
</p><p>
Unlike most system catalogs, <code class="structname">pg_database</code>
is shared across all databases of a cluster: there is only one
copy of <code class="structname">pg_database</code> per cluster, not
one per database.
</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">
Column Type
</p>
<p>
Description
</p></th></tr></thead><tbody><tr><td class="catalog_table_entry"><p class="column_definition">
<code class="structfield">oid</code> <code class="type">oid</code>
</p>
<p>
Row identifier
</p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">
<code class="structfield">datname</code> <code class="type">name</code>
</p>
<p>
Database name
</p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">
<code class="structfield">datdba</code> <code class="type">oid</code>
(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>)
</p>
<p>
Owner of the database, usually the user who created it
</p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">
<code class="structfield">encoding</code> <code class="type">int4</code>
</p>
<p>
Character encoding for this database
(<a class="link" href="functions-info.html#PG-ENCODING-TO-CHAR"><code class="function">pg_encoding_to_char()</code></a> can translate
this number to the encoding name)
</p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">
<code class="structfield">datlocprovider</code> <code class="type">char</code>
</p>
<p>
Locale provider for this database: <code class="literal">c</code> = libc,
<code class="literal">i</code> = icu
</p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">
<code class="structfield">datistemplate</code> <code class="type">bool</code>
</p>
<p>
If true, then this database can be cloned by
any user with <code class="literal">CREATEDB</code> privileges;
if false, then only superusers or the owner of
the database can clone it.
</p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">
<code class="structfield">datallowconn</code> <code class="type">bool</code>
</p>
<p>
If false then no one can connect to this database. This is
used to protect the <code class="literal">template0</code> database from being altered.
</p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">
<code class="structfield">datconnlimit</code> <code class="type">int4</code>
</p>
<p>
Sets maximum number of concurrent connections that can be made
to this database. -1 means no limit, -2 indicates the database is
invalid.
</p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">
<code class="structfield">datfrozenxid</code> <code class="type">xid</code>
</p>
<p>
All transaction IDs before this one have been replaced with a permanent
(<span class="quote">“<span class="quote">frozen</span>”</span>) 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 <code class="literal">pg_xact</code> to be shrunk.
It is the minimum of the per-table
<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.
</p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">
<code class="structfield">datminmxid</code> <code class="type">xid</code>
</p>
<p>
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 <code class="literal">pg_multixact</code> to be shrunk.
It is the minimum of the per-table
<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.
</p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">
<code class="structfield">dattablespace</code> <code class="type">oid</code>
(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>)
</p>
<p>
The default tablespace for the database.
Within this database, all tables for which
<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 zero
will be stored in this tablespace; in particular, all the non-shared
system catalogs will be there.
</p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">
<code class="structfield">datcollate</code> <code class="type">text</code>
</p>
<p>
LC_COLLATE for this database
</p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">
<code class="structfield">datctype</code> <code class="type">text</code>
</p>
<p>
LC_CTYPE for this database
</p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">
<code class="structfield">daticulocale</code> <code class="type">text</code>
</p>
<p>
ICU locale ID for this database
</p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">
<code class="structfield">datcollversion</code> <code class="type">text</code>
</p>
<p>
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.
</p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">
<code class="structfield">datacl</code> <code class="type">aclitem[]</code>
</p>
<p>
Access privileges; see <a class="xref" href="ddl-priv.html" title="5.7. Privileges">Section 5.7</a> for details
</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 15.7 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>
|
