select open change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Unsupported versions: 8.0 / 7.4 / 7.3 / 7.2 / 7.1
Historical version. PostgreSQL 7.1 reached end of support in April 2006. See the current manual for supported releases.

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.

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

Report a documentation issue

Read the upstream documentation. For corrections, first check the current manual.