PG_DATABASE
PG_DATABASE records information about available databases.
Table 1 PG_DATABASE columns
Name | Type | Description |
---|
oid | oid | Row identifier (hidden attribute, which must be specified) |
datname | name | Database name |
datdba | oid | Owner of the database, usually the user who created it |
encoding | integer | Character encoding for the database |
datcollate | name | Sequence used by the database |
datctype | name | Character type used by the database |
datistemplate | Boolean | Whether the database can be used as a template database |
datallowconn | Boolean | If the value is false, no one can connect to this database. This column is used to protect the template0 database from being altered. |
datconnlimit | integer | Maximum number of concurrent connections allowed on this database. The value -1 indicates no limit. |
datlastsysoid | oid | Last system OID in the database |
datfrozenxid | xid32 | Tracks whether the database needs to be vacuumed to prevent transaction ID wraparound. To ensure forward compatibility, this column is reserved. The datfrozenxid64 column is added to record the information. |
dattablespace | oid | Default tablespace of the database |
datcompatibility | name | Database compatibility mode |
datacl | aclitem[] | Access permissions |
datfrozenxid64 | xid | Tracks whether the database needs to be vacuumed to prevent transaction ID wraparound. |
openGauss 2024-09-07 01:00:29