24th September 2020: PostgreSQL 13 Released!
Supported Versions: Current (13) / 12 / 11 / 10 / 9.6 / 9.5
Development Versions: devel
Unsupported versions: 9.4 / 9.3 / 9.2 / 9.1 / 9.0
This documentation is for an unsupported version of PostgreSQL.
You may want to view the same page for the current version, or one of the other supported versions listed above instead.

45.15. pg_db_role_setting

The catalog pg_db_role_setting records the default values that have been set for run-time configuration variables, for each role and database combination.

Unlike most system catalogs, pg_db_role_setting is shared across all databases of a cluster: there is only one copy of pg_db_role_setting per cluster, not one per database.

Table 45-15. pg_db_role_setting Columns

Name Type References Description
setdatabase oid pg_database.oid The OID of the database the setting is applicable to, or zero if not database-specific
setrole oid pg_authid.oid The OID of the role the setting is applicable to, or zero if not role-specific
setconfig text[]   Defaults for run-time configuration variables