↑↓ select ↵ open ⌫ change scope Open full search

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

Supported versions: Current (18) / 17 / 16 / 15 / 14
Development versions: 19 / devel
Unsupported versions: 13 / 12 / 11 / 10 / 9.6 / 9.5 / 9.4 / 9.3 / 9.2 / 9.1 / 9.0 / 8.4 / 8.3 / 8.2 / 8.1
Historical version. PostgreSQL 9.1 reached end of support in October 2016. See the current version for supported releases.
PostgreSQL 9.1.24 Documentation
Prev Up Chapter 45. System Catalogs Next

45.54. 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 45-55. 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

Report a documentation issue

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