Movatterモバイル変換


[0]ホーム

URL:



Facebook
Postgres Pro
Facebook
Downloads
51.15. pg_database
Prev UpChapter 51. System CatalogsHome Next

51.15. pg_database

The catalogpg_database stores information about the available databases. Databases are created with theCREATE DATABASE command. ConsultChapter 21 for details about the meaning of some of the parameters.

Unlike most system catalogs,pg_database is shared across all databases of a cluster: there is only one copy ofpg_database per cluster, not one per database.

Table 51.15. pg_database Columns

Column Type

Description

oidoid

Row identifier

datnamename

Database name

datdbaoid (referencespg_authid.oid)

Owner of the database, usually the user who created it

encodingint4

Character encoding for this database (pg_encoding_to_char() can translate this number to the encoding name)

datcollatename

LC_COLLATE for this database

datctypename

LC_CTYPE for this database

datistemplatebool

If true, then this database can be cloned by any user withCREATEDB privileges; if false, then only superusers or the owner of the database can clone it.

datallowconnbool

If false then no one can connect to this database. This is used to protect thetemplate0 database from being altered.

datconnlimitint4

Sets maximum number of concurrent connections that can be made to this database. -1 means no limit, -2 indicates the database is invalid.

datlastsysoidoid

Last system OID in the database; useful particularly topg_dump

datfrozenxidxid

All transaction IDs before this one have been replaced with a permanent (frozen) 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 allowpg_xact to be shrunk. It is the minimum of the per-tablepg_class.relfrozenxid values.

datminmxidxid

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 allowpg_multixact to be shrunk. It is the minimum of the per-tablepg_class.relminmxid values.

dattablespaceoid (referencespg_tablespace.oid)

The default tablespace for the database. Within this database, all tables for whichpg_class.reltablespace is zero will be stored in this tablespace; in particular, all the non-shared system catalogs will be there.

dataclaclitem[]

Access privileges; seeSection 5.7 for details



Prev Up Next
51.14. pg_conversion Home 51.16. pg_db_role_setting
pdfepub
Go to Postgres Pro Standard 14
By continuing to browse this website, you agree to the use of cookies. Go toPrivacy Policy.

[8]ページ先頭

©2009-2025 Movatter.jp