pg_group
The view pg_group exists for backwards compatibility: it emulates a catalog that existed in PostgreSQL before version 8.1. 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.
English manual coverage begins with PostgreSQL 7.4. Source history and runtime observations have their own recorded version boundaries.
Reading PG 18·Select a recorded version
- kind
- view
- lang
- en
- measured attributes
- true
- metadata release
- 18.6
- runtime columns
- groname, grosysid, grolist
- runtime verified
- false
- source
- english-manual
Definition PG 18
The view pg_group exists for backwards compatibility: it emulates a catalog that existed in PostgreSQL before version 8.1. 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.
Catalog columns
| Column | Type | Nullability | Description |
|---|---|---|---|
| groname | name | Nullable | Name of the group |
| grosysid | oid | Nullable | ID of this group |
| grolist | oid[] | Nullable | An array containing the IDs of the roles in this group |
Compare versions
Source references
Full definition and evidence JSON
Definition sources
center · PostgreSQL 18 · catalog-bilingual-repair:b7369dce22862a0b6118d0abe63d3c63e885b3e2ac1936fb735efa05e96e89eb
Text language: en · catalog-bilingual-repair:b7369dce22862a0b6118d0abe63d3c63e885b3e2ac1936fb735efa05e96e89eb