pg_db_role_setting
The pg_db_role_setting system catalog table records the default values of configuration parameters for each role and database combination.
There is a single copy of pg_db_role_setting per Greengage DB cluster.
This system catalog table is shared across all databases.
| Column | Type | References | Description |
|---|---|---|---|
setdatabase |
oid |
pg_database.oid |
The database to which the setting is applicable, or |
setrole |
oid |
pg_authid.oid |
The role to which the setting is applicable, or |
setconfig |
text[] |
— |
Per-database- and per-role-specific defaults for user-settable server configuration parameters |