PG_DATABASE
PG_DATABASE records information about the available databases.
Name |
Type |
Description |
---|---|---|
datname |
name |
Database name |
datdba |
oid |
Owner of the database, usually the user who created it |
encoding |
integer |
Database encoding. You can use pg_encoding_to_char() to convert this number to the encoding name. |
datcollate |
name |
Sequence used by the database |
datctype |
name |
Character type used by the database |
datistemplate |
boolean |
Whether this column can serve as a template database |
datallowconn |
boolean |
If false then 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. -1 indicates no limit. |
datlastsysoid |
oid |
Last system OID in the database |
datfrozenxid |
xid32 |
Tracks whether the database needs to be vacuumed in order 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 in order to prevent transaction ID wraparound. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot