{"Entry":{"collection":"catalog","key":"pg_auth_members","name":"pg_auth_members","aliases":[],"metadata":{"changed_in":["16"],"changes":[{"added":[],"attributes":[],"description_changed":false,"descriptions":[],"from":"8.0","order":false,"removed":[],"status":"added","to":"8.1","types":[]},{"added":[],"attributes":[],"description_changed":false,"descriptions":[{"from":"True if member may grant membership in roleid to others","name":"admin_option","to":"True if member can grant membership in roleid to others"}],"from":"8.2","listing":[],"order":false,"removed":[],"status":"reworded","to":"8.3","types":[],"unlisted":[]},{"added":["oid","inherit_option","set_option"],"attributes":[],"description_changed":false,"descriptions":[],"from":"15","listing":[],"order":false,"removed":[],"status":"changed","to":"16","types":[],"unlisted":[]}],"column_count":7,"content_hash":"19d7865b3a8d36d7c0be481005fc1a4f2a5e662e22eaaac6a958953e1bbcca0b","derived_content_hash":"9d92683370b33f782fd8ca7c3061706d8a9b0e6c64120cfcd859893acc0633e6","first_version":"8.1","imported_at":"2026-09-30T00:40:55.353812+08:00","kind":"catalog","last_version":"20","name":"pg_auth_members","position":7,"present_in":["8.1","8.2","8.3","8.4","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:885c49c059d688c75f88b07b5d1235dcd39815e0b6b6f8c10489ccf676e355b6","summary":"The catalog pg_auth_members shows the membership relations between roles.","summary_zh":"目录 pg_auth_members 展示了角色之间的成员关系。允许任何无环的关系集合。"}},"Definition":{"Collection":"catalog","Key":"pg_auth_members","SourceDatabase":"center","Version":"18","SourceTable":"catalog","SourceKey":"pg_auth_members","SourceRevision":"catalog-bilingual-repair:885c49c059d688c75f88b07b5d1235dcd39815e0b6b6f8c10489ccf676e355b6","Facts":{"columns":[{"array_dimensions":0,"attnum":1,"description":"Row identifier","description_zh":"行标识符","documented":true,"documented_name":"oid","hidden":false,"name":"oid","not_null":true,"references":"","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":2,"description":"ID of a role that has a member","description_zh":"拥有成员的角色的 ID","documented":true,"documented_name":"roleid","hidden":false,"name":"roleid","not_null":true,"references":"pg_authid.oid","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":3,"description":"ID of a role that is a member of roleid","description_zh":"roleid 的成员角色的 ID","documented":true,"documented_name":"member","hidden":false,"name":"member","not_null":true,"references":"pg_authid.oid","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":4,"description":"ID of the role that granted this membership","description_zh":"授权此成员关系的角色的 ID","documented":true,"documented_name":"grantor","hidden":false,"name":"grantor","not_null":true,"references":"pg_authid.oid","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":5,"description":"True if member can grant membership in roleid to others","description_zh":"如果 member 能够将 roleid 的成员资格授予其他角色，则为真","documented":true,"documented_name":"admin_option","hidden":false,"name":"admin_option","not_null":true,"references":"","type":"bool","type_modifier":-1,"type_oid":16,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":6,"description":"True if the member automatically inherits the privileges of the granted role","description_zh":"如果成员会自动继承被授予角色的权限，则为真","documented":true,"documented_name":"inherit_option","hidden":false,"name":"inherit_option","not_null":true,"references":"","type":"bool","type_modifier":-1,"type_oid":16,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":7,"description":"True if the member can SET ROLE to the granted role","description_zh":"如果成员可以 SET ROLE 到被授予的角色，则为真","documented":true,"documented_name":"set_option","hidden":false,"name":"set_option","not_null":true,"references":"","type":"bool","type_modifier":-1,"type_oid":16,"zh_from":"same-version-manual"}],"description":"The catalog pg_auth_members shows the membership relations between roles. Any non-circular set of relationships is allowed.\n\nBecause user identities are cluster-wide, pg_auth_members is shared across all databases of a cluster: there is only one copy of pg_auth_members per cluster, not one per database.","description_zh":"目录 pg_auth_members 展示了角色之间的成员关系。允许任何无环的关系集合。\n\n由于用户身份是集簇范围的，pg_auth_members 在一个集簇的所有数据库之间共享：在一个集簇中只有一份 pg_auth_members 拷贝，而不是每个数据库一份。","description_zh_html":"\u003cp\u003e目录 pg_auth_members 展示了角色之间的成员关系。允许任何无环的关系集合。\u003c/p\u003e\n\u003cp\u003e由于用户身份是集簇范围的，pg_auth_members 在一个集簇的所有数据库之间共享：在一个集簇中只有一份 pg_auth_members 拷贝，而不是每个数据库一份。\u003c/p\u003e","doc":{"anchor":"id-1.10.4.11.5","file":"catalog-pg-auth-members.html","lang":"en","sha256":"a9074fddc29e047b3b0d6761fa65f71a06236f7c671fdc7d20939a842aad716f","slug":"18"},"kind":"catalog","lang":"en","measured_attributes":true,"metadata_release":"18.6","runtime_columns":["oid","roleid","member","grantor","admin_option","inherit_option","set_option"],"runtime_verified":false,"source":"english-manual","sources":[{"evidence":[{"build_id":107,"kind":"same-version-manual","locale":"zh-Hans","page":"catalog-pg-auth-members.html","sha256":"8e274efe6abeba3cf65382b9dad3445afa543ba2ebd7753cd267da6e16125914","source_revision":"unknown:rendered-translation-baseline","translation_revision":"git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b","version":"18"}],"kind":"catalog-bilingual-repair","prior_source_revision":"english-manuals:651a007f00d2521d9876eb03a39aacde8b6321854e5662524cac92cdcd58457e","version":"18"}],"zh_from":"same-version-manual"},"ManualEvidence":{"doc":{"anchor":"id-1.10.4.11.5","file":"catalog-pg-auth-members.html","lang":"en","sha256":"a9074fddc29e047b3b0d6761fa65f71a06236f7c671fdc7d20939a842aad716f","slug":"18"},"sources":[{"evidence":[{"build_id":107,"kind":"same-version-manual","locale":"zh-Hans","page":"catalog-pg-auth-members.html","sha256":"8e274efe6abeba3cf65382b9dad3445afa543ba2ebd7753cd267da6e16125914","source_revision":"unknown:rendered-translation-baseline","translation_revision":"git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b","version":"18"}],"kind":"catalog-bilingual-repair","prior_source_revision":"english-manuals:651a007f00d2521d9876eb03a39aacde8b6321854e5662524cac92cdcd58457e","version":"18"}]},"MeasuredEvidence":{"measured_attributes":true,"metadata_release":"18.6","runtime_columns":["oid","roleid","member","grantor","admin_option","inherit_option","set_option"],"runtime_verified":false}},"Text":{"Collection":"catalog","Key":"pg_auth_members","SourceDatabase":"center","Version":"18","Locale":"en","Title":"pg_auth_members","Summary":"The catalog pg_auth_members shows the membership relations between roles. Any non-circular set of relationships is allowed.\n\nBecause user identities are cluster-wide, pg_auth_members is shared across all databases of a cluster: there is only one copy of pg_auth_members per cluster, not one per database.","BodyHTML":"\u003cp\u003eThe catalog pg_auth_members shows the membership relations between roles. Any non-circular set of relationships is allowed.\n\nBecause user identities are cluster-wide, pg_auth_members is shared across all databases of a cluster: there is only one copy of pg_auth_members per cluster, not one per database.\u003c/p\u003e","SourceRevision":"catalog-bilingual-repair:885c49c059d688c75f88b07b5d1235dcd39815e0b6b6f8c10489ccf676e355b6","ContentHash":"b71bd3b24c0d9f38694a54b1fe3502786b3b421dc861e2c9d47eb3fe6b84e5aa","Payload":{"columns":[{"array_dimensions":0,"attnum":1,"description":"Row identifier","description_zh":"行标识符","documented":true,"documented_name":"oid","hidden":false,"name":"oid","not_null":true,"references":"","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":2,"description":"ID of a role that has a member","description_zh":"拥有成员的角色的 ID","documented":true,"documented_name":"roleid","hidden":false,"name":"roleid","not_null":true,"references":"pg_authid.oid","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":3,"description":"ID of a role that is a member of roleid","description_zh":"roleid 的成员角色的 ID","documented":true,"documented_name":"member","hidden":false,"name":"member","not_null":true,"references":"pg_authid.oid","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":4,"description":"ID of the role that granted this membership","description_zh":"授权此成员关系的角色的 ID","documented":true,"documented_name":"grantor","hidden":false,"name":"grantor","not_null":true,"references":"pg_authid.oid","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":5,"description":"True if member can grant membership in roleid to others","description_zh":"如果 member 能够将 roleid 的成员资格授予其他角色，则为真","documented":true,"documented_name":"admin_option","hidden":false,"name":"admin_option","not_null":true,"references":"","type":"bool","type_modifier":-1,"type_oid":16,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":6,"description":"True if the member automatically inherits the privileges of the granted role","description_zh":"如果成员会自动继承被授予角色的权限，则为真","documented":true,"documented_name":"inherit_option","hidden":false,"name":"inherit_option","not_null":true,"references":"","type":"bool","type_modifier":-1,"type_oid":16,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":7,"description":"True if the member can SET ROLE to the granted role","description_zh":"如果成员可以 SET ROLE 到被授予的角色，则为真","documented":true,"documented_name":"set_option","hidden":false,"name":"set_option","not_null":true,"references":"","type":"bool","type_modifier":-1,"type_oid":16,"zh_from":"same-version-manual"}],"description":"The catalog pg_auth_members shows the membership relations between roles. Any non-circular set of relationships is allowed.\n\nBecause user identities are cluster-wide, pg_auth_members is shared across all databases of a cluster: there is only one copy of pg_auth_members per cluster, not one per database."}},"RequestedLocale":"en","Fallback":false,"Versions":["10","11","12","13","14","15","16","17","18","19","20","8.1","8.2","8.3","8.4","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}