Updated on 2024-05-07 GMT+08:00

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

Specifies whether the database can be used as a template database.

  • true: allowed.
  • false: not allowed.

datallowconn

boolean

This column is used to protect the template0 database from being altered.

  • true: Users can connect to the database.
  • false: No user can connect to the database.

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. This column is discarded in the current version. 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. Currently, four compatible modes are supported: PG, ORA, MYSQL, and TD.

datacl

aclitem[]

Access permission.

datfrozenxid64

xid

Tracks whether the database needs to be vacuumed to prevent transaction ID wraparound.

datminmxid

xid

All multi-transaction IDs before this one have been replaced with a transaction ID in the database. This is used to track whether the database needs to be vacuumed in order to prevent transaction IDs wraparound or to allow PG_CLOG to be shrunk. It is the minimum value of relminmxid in 12.2.51 PG_CLASS of all tables in the database.

dattimezone

name

Database time zone. The default is PRC.