PostgreSQL 8.2.6 Documentation
Prev Fast Backward Chapter 43. System Catalogs Fast Forward Next

43.37. 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 43-37. 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