pg_auth_members

包含数据库组成员信息的系统表

pg_auth_members 是一个系统目录表，其中包含数据库组成员信息。

它取代了之前的系统目录表 pg_group，该表现在是一个视图。

该表在集群的所有数据库之间共享。

psql 命令

\du 提供数据库用户及其角色成员资格列表
\du+ 提供与 \du 相同的信息，并包含用户的描述

系统函数

系统函数 pg_has_role() 可用于确定特定用户是否为特定角色的成员。

按 PostgreSQL 版本定义

pg_auth_members (PostgreSQL 19)

            Table "pg_catalog.pg_auth_members"
     Column     |  Type   | Collation | Nullable | Default 
----------------+---------+-----------+----------+---------
 oid            | oid     |           | not null | 
 roleid         | oid     |           | not null | 
 member         | oid     |           | not null | 
 grantor        | oid     |           | not null | 
 admin_option   | boolean |           | not null | 
 inherit_option | boolean |           | not null | 
 set_option     | boolean |           | not null | 
Indexes:
    "pg_auth_members_oid_index" PRIMARY KEY, btree (oid), tablespace "pg_global"
    "pg_auth_members_grantor_index" btree (grantor), tablespace "pg_global"
    "pg_auth_members_member_role_index" UNIQUE CONSTRAINT, btree (member, roleid, grantor), tablespace "pg_global"
    "pg_auth_members_role_member_index" UNIQUE CONSTRAINT, btree (roleid, member, grantor), tablespace "pg_global"
Tablespace: "pg_global"

文档: pg_auth_members

pg_auth_members (PostgreSQL 18)

            Table "pg_catalog.pg_auth_members"
     Column     |  Type   | Collation | Nullable | Default 
----------------+---------+-----------+----------+---------
 oid            | oid     |           | not null | 
 roleid         | oid     |           | not null | 
 member         | oid     |           | not null | 
 grantor        | oid     |           | not null | 
 admin_option   | boolean |           | not null | 
 inherit_option | boolean |           | not null | 
 set_option     | boolean |           | not null | 
Indexes:
    "pg_auth_members_oid_index" PRIMARY KEY, btree (oid), tablespace "pg_global"
    "pg_auth_members_grantor_index" btree (grantor), tablespace "pg_global"
    "pg_auth_members_member_role_index" UNIQUE CONSTRAINT, btree (member, roleid, grantor), tablespace "pg_global"
    "pg_auth_members_role_member_index" UNIQUE CONSTRAINT, btree (roleid, member, grantor), tablespace "pg_global"
Tablespace: "pg_global"

文档: pg_auth_members

pg_auth_members (PostgreSQL 17)

            Table "pg_catalog.pg_auth_members"
     Column     |  Type   | Collation | Nullable | Default 
----------------+---------+-----------+----------+---------
 oid            | oid     |           | not null | 
 roleid         | oid     |           | not null | 
 member         | oid     |           | not null | 
 grantor        | oid     |           | not null | 
 admin_option   | boolean |           | not null | 
 inherit_option | boolean |           | not null | 
 set_option     | boolean |           | not null | 
Indexes:
    "pg_auth_members_oid_index" PRIMARY KEY, btree (oid), tablespace "pg_global"
    "pg_auth_members_grantor_index" btree (grantor), tablespace "pg_global"
    "pg_auth_members_member_role_index" UNIQUE CONSTRAINT, btree (member, roleid, grantor), tablespace "pg_global"
    "pg_auth_members_role_member_index" UNIQUE CONSTRAINT, btree (roleid, member, grantor), tablespace "pg_global"
Tablespace: "pg_global"

文档: pg_auth_members

pg_auth_members (PostgreSQL 16)

            Table "pg_catalog.pg_auth_members"
     Column     |  Type   | Collation | Nullable | Default 
----------------+---------+-----------+----------+---------
 oid            | oid     |           | not null | 
 roleid         | oid     |           | not null | 
 member         | oid     |           | not null | 
 grantor        | oid     |           | not null | 
 admin_option   | boolean |           | not null | 
 inherit_option | boolean |           | not null | 
 set_option     | boolean |           | not null | 
Indexes:
    "pg_auth_members_oid_index" PRIMARY KEY, btree (oid), tablespace "pg_global"
    "pg_auth_members_grantor_index" btree (grantor), tablespace "pg_global"
    "pg_auth_members_member_role_index" UNIQUE CONSTRAINT, btree (member, roleid, grantor), tablespace "pg_global"
    "pg_auth_members_role_member_index" UNIQUE CONSTRAINT, btree (roleid, member, grantor), tablespace "pg_global"
Tablespace: "pg_global"

文档: pg_auth_members

pg_auth_members (PostgreSQL 15)

           Table "pg_catalog.pg_auth_members"
    Column    |  Type   | Collation | Nullable | Default 
--------------+---------+-----------+----------+---------
 roleid       | oid     |           | not null | 
 member       | oid     |           | not null | 
 grantor      | oid     |           | not null | 
 admin_option | boolean |           | not null | 
Indexes:
    "pg_auth_members_role_member_index" PRIMARY KEY, btree (roleid, member), tablespace "pg_global"
    "pg_auth_members_member_role_index" UNIQUE CONSTRAINT, btree (member, roleid), tablespace "pg_global"
Tablespace: "pg_global"

文档: pg_auth_members

pg_auth_members (PostgreSQL 14)

           Table "pg_catalog.pg_auth_members"
    Column    |  Type   | Collation | Nullable | Default 
--------------+---------+-----------+----------+---------
 roleid       | oid     |           | not null | 
 member       | oid     |           | not null | 
 grantor      | oid     |           | not null | 
 admin_option | boolean |           | not null | 
Indexes:
    "pg_auth_members_role_member_index" PRIMARY KEY, btree (roleid, member), tablespace "pg_global"
    "pg_auth_members_member_role_index" UNIQUE CONSTRAINT, btree (member, roleid), tablespace "pg_global"
Tablespace: "pg_global"

文档: pg_auth_members

pg_auth_members (PostgreSQL 13)

           Table "pg_catalog.pg_auth_members"
    Column    |  Type   | Collation | Nullable | Default 
--------------+---------+-----------+----------+---------
 roleid       | oid     |           | not null | 
 member       | oid     |           | not null | 
 grantor      | oid     |           | not null | 
 admin_option | boolean |           | not null | 
Indexes:
    "pg_auth_members_member_role_index" UNIQUE, btree (member, roleid), tablespace "pg_global"
    "pg_auth_members_role_member_index" UNIQUE, btree (roleid, member), tablespace "pg_global"
Tablespace: "pg_global"

文档: pg_auth_members

pg_auth_members (PostgreSQL 12)

           Table "pg_catalog.pg_auth_members"
    Column    |  Type   | Collation | Nullable | Default 
--------------+---------+-----------+----------+---------
 roleid       | oid     |           | not null | 
 member       | oid     |           | not null | 
 grantor      | oid     |           | not null | 
 admin_option | boolean |           | not null | 
Indexes:
    "pg_auth_members_member_role_index" UNIQUE, btree (member, roleid), tablespace "pg_global"
    "pg_auth_members_role_member_index" UNIQUE, btree (roleid, member), tablespace "pg_global"
Tablespace: "pg_global"

文档: pg_auth_members

pg_auth_members (PostgreSQL 11)

           Table "pg_catalog.pg_auth_members"
    Column    |  Type   | Collation | Nullable | Default 
--------------+---------+-----------+----------+---------
 roleid       | oid     |           | not null | 
 member       | oid     |           | not null | 
 grantor      | oid     |           | not null | 
 admin_option | boolean |           | not null | 
Indexes:
    "pg_auth_members_member_role_index" UNIQUE, btree (member, roleid), tablespace "pg_global"
    "pg_auth_members_role_member_index" UNIQUE, btree (roleid, member), tablespace "pg_global"
Tablespace: "pg_global"

文档: pg_auth_members

pg_auth_members (PostgreSQL 10)

           Table "pg_catalog.pg_auth_members"
    Column    |  Type   | Collation | Nullable | Default 
--------------+---------+-----------+----------+---------
 roleid       | oid     |           | not null | 
 member       | oid     |           | not null | 
 grantor      | oid     |           | not null | 
 admin_option | boolean |           | not null | 
Indexes:
    "pg_auth_members_member_role_index" UNIQUE, btree (member, roleid), tablespace "pg_global"
    "pg_auth_members_role_member_index" UNIQUE, btree (roleid, member), tablespace "pg_global"
Tablespace: "pg_global"

文档: pg_auth_members

pg_auth_members (PostgreSQL 9.6)

 Table "pg_catalog.pg_auth_members"
    Column    |  Type   | Modifiers 
--------------+---------+-----------
 roleid       | oid     | not null
 member       | oid     | not null
 grantor      | oid     | not null
 admin_option | boolean | not null
Indexes:
    "pg_auth_members_member_role_index" UNIQUE, btree (member, roleid), tablespace "pg_global"
    "pg_auth_members_role_member_index" UNIQUE, btree (roleid, member), tablespace "pg_global"
Tablespace: "pg_global"

文档: pg_auth_members

pg_auth_members (PostgreSQL 9.5)

 Table "pg_catalog.pg_auth_members"
    Column    |  Type   | Modifiers 
--------------+---------+-----------
 roleid       | oid     | not null
 member       | oid     | not null
 grantor      | oid     | not null
 admin_option | boolean | not null
Indexes:
    "pg_auth_members_member_role_index" UNIQUE, btree (member, roleid), tablespace "pg_global"
    "pg_auth_members_role_member_index" UNIQUE, btree (roleid, member), tablespace "pg_global"
Tablespace: "pg_global"

文档: pg_auth_members

pg_auth_members (PostgreSQL 9.4)

 Table "pg_catalog.pg_auth_members"
    Column    |  Type   | Modifiers 
--------------+---------+-----------
 roleid       | oid     | not null
 member       | oid     | not null
 grantor      | oid     | not null
 admin_option | boolean | not null
Indexes:
    "pg_auth_members_member_role_index" UNIQUE, btree (member, roleid), tablespace "pg_global"
    "pg_auth_members_role_member_index" UNIQUE, btree (roleid, member), tablespace "pg_global"
Tablespace: "pg_global"

文档: pg_auth_members

pg_auth_members (PostgreSQL 9.3)

 Table "pg_catalog.pg_auth_members"
    Column    |  Type   | Modifiers 
--------------+---------+-----------
 roleid       | oid     | not null
 member       | oid     | not null
 grantor      | oid     | not null
 admin_option | boolean | not null
Indexes:
    "pg_auth_members_member_role_index" UNIQUE, btree (member, roleid), tablespace "pg_global"
    "pg_auth_members_role_member_index" UNIQUE, btree (roleid, member), tablespace "pg_global"
Tablespace: "pg_global"

文档: pg_auth_members

pg_auth_members (PostgreSQL 9.2)

 Table "pg_catalog.pg_auth_members"
    Column    |  Type   | Modifiers 
--------------+---------+-----------
 roleid       | oid     | not null
 member       | oid     | not null
 grantor      | oid     | not null
 admin_option | boolean | not null
Indexes:
    "pg_auth_members_member_role_index" UNIQUE, btree (member, roleid), tablespace "pg_global"
    "pg_auth_members_role_member_index" UNIQUE, btree (roleid, member), tablespace "pg_global"
Tablespace: "pg_global"

文档: pg_auth_members

pg_auth_members (PostgreSQL 9.1)

 Table "pg_catalog.pg_auth_members"
    Column    |  Type   | Modifiers 
--------------+---------+-----------
 roleid       | oid     | not null
 member       | oid     | not null
 grantor      | oid     | not null
 admin_option | boolean | not null
Indexes:
    "pg_auth_members_member_role_index" UNIQUE, btree (member, roleid), tablespace "pg_global"
    "pg_auth_members_role_member_index" UNIQUE, btree (roleid, member), tablespace "pg_global"
Tablespace: "pg_global"

文档: pg_auth_members

pg_auth_members (PostgreSQL 9.0)

 Table "pg_catalog.pg_auth_members"
    Column    |  Type   | Modifiers 
--------------+---------+-----------
 roleid       | oid     | not null
 member       | oid     | not null
 grantor      | oid     | not null
 admin_option | boolean | not null
Indexes:
    "pg_auth_members_member_role_index" UNIQUE, btree (member, roleid), tablespace "pg_global"
    "pg_auth_members_role_member_index" UNIQUE, btree (roleid, member), tablespace "pg_global"
Tablespace: "pg_global"

文档: pg_auth_members

pg_auth_members (PostgreSQL 8.4)

 Table "pg_catalog.pg_auth_members"
    Column    |  Type   | Modifiers 
--------------+---------+-----------
 roleid       | oid     | not null
 member       | oid     | not null
 grantor      | oid     | not null
 admin_option | boolean | not null
Indexes:
    "pg_auth_members_member_role_index" UNIQUE, btree (member, roleid), tablespace "pg_global"
    "pg_auth_members_role_member_index" UNIQUE, btree (roleid, member), tablespace "pg_global"
Triggers:
    pg_sync_pg_auth_members AFTER INSERT OR DELETE OR UPDATE ON pg_auth_members FOR EACH STATEMENT EXECUTE PROCEDURE flatfile_update_trigger()
Tablespace: "pg_global"

文档: pg_auth_members

pg_auth_members (PostgreSQL 8.3)

 Table "pg_catalog.pg_auth_members"
    Column    |  Type   | Modifiers 
--------------+---------+-----------
 roleid       | oid     | not null
 member       | oid     | not null
 grantor      | oid     | not null
 admin_option | boolean | not null
Indexes:
    "pg_auth_members_member_role_index" UNIQUE, btree (member, roleid), tablespace "pg_global"
    "pg_auth_members_role_member_index" UNIQUE, btree (roleid, member), tablespace "pg_global"
Triggers:
    pg_sync_pg_auth_members AFTER INSERT OR DELETE OR UPDATE ON pg_auth_members FOR EACH STATEMENT EXECUTE PROCEDURE flatfile_update_trigger()
Tablespace: "pg_global"

文档: pg_auth_members

pg_auth_members (PostgreSQL 8.2)

 Table "pg_catalog.pg_auth_members"
    Column    |  Type   | Modifiers 
--------------+---------+-----------
 roleid       | oid     | not null
 member       | oid     | not null
 grantor      | oid     | not null
 admin_option | boolean | not null
Indexes:
    "pg_auth_members_member_role_index" UNIQUE, btree (member, roleid), tablespace "pg_global"
    "pg_auth_members_role_member_index" UNIQUE, btree (roleid, member), tablespace "pg_global"
Triggers:
    pg_sync_pg_auth_members AFTER INSERT OR DELETE OR UPDATE ON pg_auth_members FOR EACH STATEMENT EXECUTE PROCEDURE flatfile_update_trigger()
Tablespace: "pg_global"

文档: pg_auth_members

变更历史

PostgreSQL 16
- 添加了列 set_option (commit 3d14e171)
PostgreSQL 9.0
- 移除了 pg_sync_pg_authmembers 触发器 (commit a8bb8eb5)
PostgreSQL 8.1
- 添加（提交 7762619e）

示例

postgres=# SELECT * FROM pg_auth_members;
 roleid | member | grantor | admin_option 
--------+--------+---------+--------------
   3374 |   3373 |      10 | f
   3375 |   3373 |      10 | f
   3377 |   3373 |      10 | f
(3 rows)

参考资料

PostgreSQL 文档： pg_auth_members

另请参阅

pg_authid

反馈

请在此处提交关于 "pg_auth_members" 的任何评论、建议或更正。

版本图表

实用概述

有用链接

咖啡

目录

pg_auth_members

psql 命令

系统函数

按 PostgreSQL 版本定义

pg_auth_members (PostgreSQL 19)

pg_auth_members (PostgreSQL 18)

pg_auth_members (PostgreSQL 17)

pg_auth_members (PostgreSQL 16)

pg_auth_members (PostgreSQL 15)

pg_auth_members (PostgreSQL 14)

pg_auth_members (PostgreSQL 13)

pg_auth_members (PostgreSQL 12)

pg_auth_members (PostgreSQL 11)

pg_auth_members (PostgreSQL 10)

pg_auth_members (PostgreSQL 9.6)

pg_auth_members (PostgreSQL 9.5)

pg_auth_members (PostgreSQL 9.4)

pg_auth_members (PostgreSQL 9.3)

pg_auth_members (PostgreSQL 9.2)

pg_auth_members (PostgreSQL 9.1)

pg_auth_members (PostgreSQL 9.0)

pg_auth_members (PostgreSQL 8.4)

pg_auth_members (PostgreSQL 8.3)

pg_auth_members (PostgreSQL 8.2)

变更历史

示例

参考资料

分类

另请参阅

反馈