PG_DATABASE_INFO - Amazon Redshift
Table columns
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

Amazon Redshift will no longer support the creation of new Python UDFs starting Patch 198. Existing Python UDFs will continue to function until June 30, 2026. For more information, see the blog post .

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.