pg_database
The pg_database system catalog stores information about the databases available in the cluster. It mimics the pg_database PostgreSQL system catalog.
Columns
The following columns are available for querying in pg_database:
| Column | Type | Description |
|---|---|---|
|
|
Object identifier for the database |
|
|
Database name |
|
|
OID of the role that owns the database |
|
|
Character encoding ID for the database (6 = UTF-8) |
|
|
Locale provider |
|
|
Whether this is a template database |
|
|
Whether connections to this database are allowed |
|
|
Connection limit ( |
|
|
Frozen transaction ID |
|
|
Minimum multixact ID |
|
|
OID of the default tablespace for the database |
|
|
LC_COLLATE setting for the database |
|
|
LC_CTYPE setting for the database |
|
|
ICU locale for the database |
|
|
ICU rules for the database |
|
|
Collation version string |
|
|
Access privileges |
