14th November 2019: PostgreSQL 12.1, 11.6, 10.11, 9.6.16, 9.5.20, and 9.4.25 Released!
Supported Versions: Current (12) / 11 / 10 / 9.6 / 9.5 / 9.4
Development Versions: devel
Unsupported versions: 9.3 / 9.2 / 9.1 / 9.0 / 8.4 / 8.3 / 8.2 / 8.1
PostgreSQL 9.4.25 Documentation
Prev Up Chapter 48. System Catalogs Next

48.58. 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.

Table 48-59. pg_group Columns

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
Prev Home Next
pg_cursors Up pg_indexes

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.