{"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":"1a1b48795158b1ef0a84b4ba83c188e31339e4081a2644342b5446c3461e1ad1","derived_content_hash":"0142146efffb8a540b6923790fc284a6b85ab3288b031654851d08d3cad32d71","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":"catalog-bilingual-repair:66ab44159fe4a8318c62193a7f3d9d2162fe24ce7690e9560789e623006c7a05","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":"目录 pg_db_role_setting 为每个角色与数据库组合记录运行时配置变量的默认值。"}},"Definition":{"Collection":"catalog","Key":"pg_db_role_setting","SourceDatabase":"center","Version":"18","SourceTable":"catalog","SourceKey":"pg_db_role_setting","SourceRevision":"catalog-bilingual-repair:66ab44159fe4a8318c62193a7f3d9d2162fe24ce7690e9560789e623006c7a05","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":"此设置适用的数据库 OID；如果不与特定数据库相关，则为零","documented":true,"documented_name":"setdatabase","hidden":false,"name":"setdatabase","not_null":true,"references":"pg_database.oid","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":2,"description":"The OID of the role the setting is applicable to, or zero if not role-specific","description_zh":"此设置适用的角色 OID；如果不与特定角色相关，则为零","documented":true,"documented_name":"setrole","hidden":false,"name":"setrole","not_null":true,"references":"pg_authid.oid","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"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,"zh_from":"same-version-manual"}],"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":"目录 pg_db_role_setting 为每个角色与数据库组合记录运行时配置变量的默认值。\n\n和大部分系统目录不同，pg_db_role_setting 是在集簇的所有数据库之间共享的：在一个集簇中只有一份 pg_db_role_setting 拷贝，而不是每个数据库一份。","description_zh_html":"\u003cp\u003e目录 pg_db_role_setting 为每个角色与数据库组合记录运行时配置变量的默认值。\u003c/p\u003e\n\u003cp\u003e和大部分系统目录不同，pg_db_role_setting 是在集簇的所有数据库之间共享的：在一个集簇中只有一份 pg_db_role_setting 拷贝，而不是每个数据库一份。\u003c/p\u003e","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","sources":[{"evidence":[{"build_id":107,"kind":"same-version-manual","locale":"zh-Hans","page":"catalog-pg-db-role-setting.html","sha256":"4f8779e81e487da141d4ada21b186eb8300c57a4847c685b774faae06dda4980","source_revision":"unknown:rendered-translation-baseline","translation_revision":"git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b","version":"18"}],"kind":"catalog-bilingual-repair","prior_source_revision":"english-manuals:88df71f8ded50d20fdcac0c3285e256e5b28ac027aa103b9a77b9482ef02533a","version":"18"}],"zh_from":"same-version-manual"},"ManualEvidence":{"doc":{"anchor":"id-1.10.4.18.5","file":"catalog-pg-db-role-setting.html","lang":"en","sha256":"2adcc4a3f3275e9a22de19bd48aef7f1c9534d0e27ed2a7e2c40c648001406af","slug":"18"},"sources":[{"evidence":[{"build_id":107,"kind":"same-version-manual","locale":"zh-Hans","page":"catalog-pg-db-role-setting.html","sha256":"4f8779e81e487da141d4ada21b186eb8300c57a4847c685b774faae06dda4980","source_revision":"unknown:rendered-translation-baseline","translation_revision":"git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b","version":"18"}],"kind":"catalog-bilingual-repair","prior_source_revision":"english-manuals:88df71f8ded50d20fdcac0c3285e256e5b28ac027aa103b9a77b9482ef02533a","version":"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":"center","Version":"18","Locale":"en","Title":"pg_db_role_setting","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.\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.","BodyHTML":"\u003cp\u003eThe 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.\u003c/p\u003e","SourceRevision":"catalog-bilingual-repair:66ab44159fe4a8318c62193a7f3d9d2162fe24ce7690e9560789e623006c7a05","ContentHash":"088f0e5d7dc44e005cdc0fc674d2a502c335aff602b912588ff800cf596b9ae5","Payload":{"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":"此设置适用的数据库 OID；如果不与特定数据库相关，则为零","documented":true,"documented_name":"setdatabase","hidden":false,"name":"setdatabase","not_null":true,"references":"pg_database.oid","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":2,"description":"The OID of the role the setting is applicable to, or zero if not role-specific","description_zh":"此设置适用的角色 OID；如果不与特定角色相关，则为零","documented":true,"documented_name":"setrole","hidden":false,"name":"setrole","not_null":true,"references":"pg_authid.oid","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"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,"zh_from":"same-version-manual"}],"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."}},"RequestedLocale":"en","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}