pg_group — PostgreSQL system view

Summary

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.

(Description quoted from the official PostgreSQL documentation.)

Columns

The pg_group system view exposes the following columns (names, types and descriptions are taken verbatim from the PostgreSQL documentation):

• groname name references pg_authid.rolname
  Name of the group
• grosysid oid references pg_authid.oid
  ID of this group
• grolist oid[] references pg_authid.oid
  An array containing the IDs of the roles in this group

Related catalogs

This object references the following other system catalogs:

• groname → pg_authid

Version applicability

Present in PostgreSQL 17, 18, 19 (verified against each release’s documentation). This is a long-standing system object that also exists in earlier PostgreSQL releases.

Related & references

• PostgreSQL system catalog & view index
• Built-in function reference

Reference: PostgreSQL documentation — pg_group.