The pg_db_role_setting catalog provides information about default configuration values per role–database pair.
| Column name | Data type | Description |
|---|---|---|
setdatabase |
oid (references pg_database.oid) |
The OID of the database to which the setting applies.0 – Not database-specific. |
setrole |
oid (references pg_authid.oid) |
The OID of the role to which the setting applies.0 – Not role-specific. |
setconfig |
text[] |
The defaults for run-time configuration variables. |