PostgreSQL

53.16. `pg_db_role_setting`
Prev	Up	Chapter 53. System Catalogs	Home	Next

53.16. `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 53.16. pg_db_role_setting Columns

Column Type Description

Column Type Description
`setdatabase` `oid` (references `pg_database`.`oid`) The OID of the database the setting is applicable to, or zero if not database-specific
`setrole` `oid` (references `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

setdatabase oid (references pg_database.oid)

The OID of the database the setting is applicable to, or zero if not database-specific

setrole oid (references 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

Prev	Up	Next
53.15. `pg_database`	Home	53.17. `pg_default_acl`

53.15. pg_database

Home

53.17. pg_default_acl

Submit correction

If you see anything in the documentation that is not correct, does not match your experience with the particular feature or requires further clarification, please use this form to report a documentation issue.

PostgreSQL

53.16. pg_db_role_setting #

Submit correction

53.16. `pg_db_role_setting` #