This page in other versions: 9.0 / 9.1 / 9.2 / 9.3  |  Development versions: devel

47.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 47-16. pg_db_role_setting Columns

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

Add Comment

Please use this form to add your own comments regarding your experience with particular features of PostgreSQL, clarifications of the documentation, or hints for other users. Please note, this is not a support forum, and your IP address will be logged. If you have a question or need help, please see the faq, try a mailing list, or join us on IRC. Note that submissions containing URLs or other keywords commonly found in 'spam' comments may be silently discarded. Please contact the webmaster if you think this is happening to you in error.

Proceed to the comment form.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group