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.

Kind: System catalogs
Columns in this snapshot: 3
Definition source: English manual

Columns 3

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

Column history across versions

Column	9.0	9.1	9.2	9.3	9.4	9.5	9.6	10	11	12	13	14	15	16	17	18	19	20
`setdatabase`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`setrole`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`setconfig`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●

Definition snapshot: english-manuals:6036a610183b1adbe19224921e9… · English manual source