51.71. pg_group

51.71. `pg_group`
Prev	Up	Chapter 51. System Catalogs	Home	Next

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 51.72. 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	Up	Next
51.70. `pg_file_settings`	Home	51.72. `pg_hba_file_rules`