HomeMogDBMogDB StackUqbar
v1.1

Documentation:v1.1

Supported Versions:

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.
Copyright © 2011-2024 www.enmotech.com All rights reserved.