PostgreSQL
51.9. pg_auth_members
The catalog pg_auth_members shows the membership relations between roles. Any non-circular set of relationships is allowed.
Because 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.
Table 51.9. pg_auth_members Columns
| Name | Type | References | Description |
|---|---|---|---|
|
|
|
ID of a role that has a member |
|
|
|
ID of a role that is a member of |
|
|
|
ID of the role that granted this membership |
|
|
True if |
+
| Prev | Up | Next |
|---|---|---|
51.8. |
51.10. |
Submit correction
If you see anything in the documentation that is not correct, does not match your experience with the particular feature or requires further clarification, please use this form to report a documentation issue.
Copyright © 1996-2023 The PostgreSQL Global Development Group