↑↓ 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.

Reading PG 18current·documented in 24 of 24 versions, 7.4 to 20

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

Columns 3

As listed in the PostgreSQL 18 manual.

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
Version history 1
  1. 8.0 → 8.1 changed

Definition snapshot: english-manuals:6b4627bb772ca6e42c9f0998b6b… · English manual source