PostgreSQL

PostgreSQL Elephant Logo

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

52.69. pg_file_settings

Home

52.71. pg_hba_file_rules

Copyright © 1996-2023 The PostgreSQL Global Development Group