PG_DATABASE_INFO
PG_DATABASE_INFO is an Amazon Redshift system view that extends the PostgreSQL catalog table PG_DATABASE.
PG_DATABASE_INFO is visible to all users.
Table columns
PG_DATABASE_INFO contains the following columns in addition to columns in PG_DATABASE. The oid
column in PG_DATABASE is called datid
in the PG_DATABASE_INFO table. For more information, see the
PostgreSQL documentation
Column name | Data type | Description |
---|---|---|
datid | oid | The object identifier (OID) used internally by system tables. |
datconnlimit | text | The maximum number of concurrent connections that can be made to this database. A value of -1 means no limit. |