PostgreSQL

PostgreSQL Elephant Logo

51.70. 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.71. 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.69. pg_file_settings

Home

51.71. pg_hba_file_rules

Copyright © 1996-2023 The PostgreSQL Global Development Group