| 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 |
| 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
|
| datvacuumxid | xid | | All rows inserted or deleted by transaction IDs before this one
have been marked as known committed or known aborted in this database.
This is used to determine when commit-log space can be recycled.
|
| datfrozenxid | xid | | All rows inserted by transaction IDs before this one have been
relabeled with a permanent ("frozen") transaction ID in this
database. This is useful to check whether a database must be vacuumed
soon to avoid transaction ID wrap-around problems.
|
| 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.
|