PG_DATABASE_INFO - Amazon Redshift

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.