select open change scope Open full search

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

SYSTEM CATALOGS / SYSTEM VIEWS

The view pg_group exists for backwards compatibility: it emulates a catalog that existed in PostgreSQL before version 8.1.

Kind
System views
Columns in this snapshot
3
Definition source
English manual

Columns 3

ColumnTypeDescription / reference
gronamenameName of the group
pg_authid.rolname
grosysidoidID of this group
pg_authid.oid
grolistoid[]An array containing the IDs of the roles in this group
pg_authid.oid
Column history across versions

Definition snapshot: english-manuals:b1c94272a19d59ecf05fd4eb5ea… · English manual source