This page in other versions: Unsupported versions: 7.1 / 7.2 / 7.3 / 7.4 / 8.0

3.8. pg_group

This catalog defines groups and stores what users belong to what groups. Groups are created with the CREATE GROUP command. Consult the Administrator's Guide for information about user permission management.

Because user and group identities are cluster-wide, pg_group is shared across all databases of a cluster: there is only one copy of pg_group per cluster, not one per database.

Table 3-8. pg_group Columns

Name Type References Description
groname name   Name of the group
grosysid int4   An arbitrary number to identify this group
grolist int4[] pg_shadow.usesysid An array containing the ids of the users in this group

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.

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group