# `pg_group`



The view `pg_group` exists for backwards compatibility: it emulates a catalog that existed in OushuDB. It shows the names and members of all roles that are marked as not `rolcanlogin`, which is an approximation to the set of roles that are being used as groups.



Table 1. `pg_catalog.pg_group`

| Name       | Type    | References          | Description                                            |
| ---------- | ------- | ------------------- | ------------------------------------------------------ |
| `groname`  | `name`  | `pg_authid.rolname` | Name of the group                                      |
| `grosysid` | `oid`   | `pg_authid.oid`     | ID of this group                                       |
| `grolist`  | `oid[]` | `pg_authid.oid`     | An array containing the IDs of the roles in this group |