PostgreSQL

PostgreSQL Elephant Logo

51.71. 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 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

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.

Copyright © 1996-2023 The PostgreSQL Global Development Group