| datname | name | | Database name |
| datdba | oid | pg_authid.oid | Owner of the database, usually the user who created it |
| encoding | int4 | | Character encoding for this database
(pg_encoding_to_char() can translate
this number to the encoding name) |
| datistemplate | bool | | If true then this database can be used in the
TEMPLATE clause of CREATE
DATABASE to create a new database as a clone of
this one
|
| datallowconn | bool | | If false then no one can connect to this database. This is
used to protect the template0 database from being altered
|
| datconnlimit | int4 | | Sets maximum number of concurrent connections that can be made
to this database. -1 means no limit
|
| datlastsysoid | oid | | Last system OID in the database; useful
particularly to pg_dump
|
| datfrozenxid | xid | | 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 pg_clog to be shrunk.
It is the minimum of the per-table
pg_class.relfrozenxid values
|
| dattablespace | oid | pg_tablespace.oid | The default tablespace for the database.
Within this database, all tables for which
pg_class.reltablespace is zero
will be stored in this tablespace; in particular, all the non-shared
system catalogs will be there
|
| datconfig | text[] | | Session defaults for run-time configuration variables |
| datacl | aclitem[] | | Access privileges; see
GRANT and
REVOKE
for details
|