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.

Reading PG 18current·documented in 18 of 24 versions, 9.0 to 20

7.4 8.0 8.1 8.2 8.3 8.4 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

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

Columns 3

As listed in the PostgreSQL 18 manual.

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

setdatabase

7.4 8.0 8.1 8.2 8.3 8.4 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

setrole

7.4 8.0 8.1 8.2 8.3 8.4 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

setconfig

7.4 8.0 8.1 8.2 8.3 8.4 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

Version history 1

8.4 → 9.0 added

Definition snapshot: english-manuals:88df71f8ded50d20fdcac0c3285… · English manual source