PostgreSQL
52.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 52.16. pg_db_role_setting
Columns
Column Type Description |
---|
The OID of the database the setting is applicable to, or zero if not database-specific |
The OID of the role the setting is applicable to, or zero if not role-specific |
Defaults for run-time configuration variables |
+
Prev | Up | Next |
---|---|---|
52.15. |
52.17. |
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.
Copyright © 1996-2023 The PostgreSQL Global Development Group