50.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 50.15. pg_database
Columns
Column Type Description |
---|
Row identifier |
Database name |
Owner of the database, usually the user who created it |
Character encoding for this database ( |
LC_COLLATE for this database |
LC_CTYPE for this database |
If true, then this database can be cloned by any user with |
If false then no one can connect to this database. This is used to protect the |
Sets maximum number of concurrent connections that can be made to this database. -1 means no limit, -2 indicates the database is invalid. |
Last system OID in the database; useful particularly topg_dump |
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 allow |
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 allow |
The default tablespace for the database. Within this database, all tables for which |
Access privileges; seeSection 5.7 for details |