52.8. pg_group

52.8. `pg_group`
Prev	Up	Chapter 52. System Views	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 52.8. pg_group Columns

Column Type Description
`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

Column Type

Description

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

Prev	Up	Next
52.7. `pg_file_settings`	Home	52.9. `pg_hba_file_rules`