Select your cookie preferences

We use essential cookies and similar tools that are necessary to provide our site and services. We use performance cookies to collect anonymous statistics, so we can understand how customers use our site and make improvements. Essential cookies cannot be deactivated, but you can choose “Customize” or “Decline” to decline performance cookies.

If you agree, AWS and approved third parties will also use cookies to provide useful site features, remember your preferences, and display relevant content, including relevant advertising. To accept or decline all non-essential cookies, choose “Accept” or “Decline.” To make more detailed choices, choose “Customize.”

PG_DATABASE_INFO - Amazon Redshift
This page has not been translated into your language. Request translation

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.
PrivacySite termsCookie preferences
© 2025, Amazon Web Services, Inc. or its affiliates. All rights reserved.