{"Entry":{"collection":"catalog","key":"pg_db_role_setting","name":"pg_db_role_setting","aliases":[],"metadata":{"changed_in":[],"changes":[{"added":[],"attributes":[],"description_changed":false,"descriptions":[],"from":"8.4","order":false,"removed":[],"status":"added","to":"9.0","types":[]}],"column_count":3,"content_hash":"1a840f5b98ae5c0f9b2aee745d4e1fee7eb4f29e8a555605f04dd8beee3151f5","first_version":"9.0","imported_at":"2026-09-30T00:40:55.498179+08:00","kind":"catalog","last_version":"20","name":"pg_db_role_setting","position":21,"present_in":["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"],"relation_oid":null,"relkind":"r","shared":false,"source_rev":"english-manuals:88df71f8ded50d20fdcac0c3285e256e5b28ac027aa103b9a77b9482ef02533a","summary":"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.","summary_zh":""}},"Definition":{"Collection":"catalog","Key":"pg_db_role_setting","SourceDatabase":"center","Version":"18","SourceTable":"catalog","SourceKey":"pg_db_role_setting","SourceRevision":"english-manuals:88df71f8ded50d20fdcac0c3285e256e5b28ac027aa103b9a77b9482ef02533a","Facts":{"columns":[{"array_dimensions":0,"attnum":1,"description":"The OID of the database the setting is applicable to, or zero if not database-specific","description_zh":"","documented":true,"documented_name":"setdatabase","hidden":false,"name":"setdatabase","not_null":true,"references":"pg_database.oid","type":"oid","type_modifier":-1,"type_oid":26},{"array_dimensions":0,"attnum":2,"description":"The OID of the role the setting is applicable to, or zero if not role-specific","description_zh":"","documented":true,"documented_name":"setrole","hidden":false,"name":"setrole","not_null":true,"references":"pg_authid.oid","type":"oid","type_modifier":-1,"type_oid":26},{"array_dimensions":1,"attnum":3,"description":"Defaults for run-time configuration variables","description_zh":"","documented":true,"documented_name":"setconfig","hidden":false,"name":"setconfig","not_null":false,"references":"","type":"text[]","type_modifier":-1,"type_oid":1009}],"description":"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.\n\nUnlike 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.","description_zh":"","doc":{"anchor":"id-1.10.4.18.5","file":"catalog-pg-db-role-setting.html","lang":"en","sha256":"2adcc4a3f3275e9a22de19bd48aef7f1c9534d0e27ed2a7e2c40c648001406af","slug":"18"},"kind":"catalog","lang":"en","measured_attributes":true,"metadata_release":"18.6","runtime_columns":["setdatabase","setrole","setconfig"],"runtime_verified":false,"source":"english-manual"},"ManualEvidence":{"doc":{"anchor":"id-1.10.4.18.5","file":"catalog-pg-db-role-setting.html","lang":"en","sha256":"2adcc4a3f3275e9a22de19bd48aef7f1c9534d0e27ed2a7e2c40c648001406af","slug":"18"}},"MeasuredEvidence":{"measured_attributes":true,"metadata_release":"18.6","runtime_columns":["setdatabase","setrole","setconfig"],"runtime_verified":false}},"Text":{"Collection":"catalog","Key":"pg_db_role_setting","SourceDatabase":"pgweb","Version":"18","Locale":"zh-Hans","Title":"pg_db_role_setting","Summary":"目录 pg_db_role_setting为每个角色与数据库组合记录运行时配置变量的默认值。\n\n和大部分系统目录不同，pg_db_role_setting是在集簇的所有数据库之间共享的：在一个集簇中只有一份pg_db_role_setting拷贝，而不是每个数据库一份。","BodyHTML":"\u003cp\u003e目录 pg_db_role_setting为每个角色与数据库组合记录运行时配置变量的默认值。\n\n和大部分系统目录不同，pg_db_role_setting是在集簇的所有数据库之间共享的：在一个集簇中只有一份pg_db_role_setting拷贝，而不是每个数据库一份。\u003c/p\u003e","SourceRevision":"2026-09-27@419045e","ContentHash":"f8285da58b8b8ce4766e1059b1d46852b20493cc8fd97434aa4125a5c2304906","Payload":{"columns":[{"description_zh":"此设置适用的数据库 OID；如果不与特定数据库相关，则为零","name":"setdatabase","type":"oid","zh_from":"doc"},{"description_zh":"此设置适用的角色 OID；如果不与特定角色相关，则为零","name":"setrole","type":"oid","zh_from":"doc"},{"description_zh":"运行时配置变量的默认值","name":"setconfig","type":"text[]","zh_from":"doc"}],"description_zh":"目录 pg_db_role_setting为每个角色与数据库组合记录运行时配置变量的默认值。\n\n和大部分系统目录不同，pg_db_role_setting是在集簇的所有数据库之间共享的：在一个集簇中只有一份pg_db_role_setting拷贝，而不是每个数据库一份。","zh_from":"doc"}},"RequestedLocale":"zh-Hans","Fallback":false,"Versions":["10","11","12","13","14","15","16","17","18","19","20","9.0","9.1","9.2","9.3","9.4","9.5","9.6"],"Locales":["en","zh-Hans"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}