pg_group

A system catalogue view providing the names and members of all roles that are marked as not rolcanlogin

pg_group is a system catalogue view providing the names and members of all roles that are marked as not rolcanlogin.

pg_group was created for backwards compatibility in PostgreSQL 8.1 when the former pg_group table was replaced by pg_auth_members (commit 7762619e).

Definition by PostgreSQL version

pg_group (PostgreSQL 13)

            View "pg_catalog.pg_group"
  Column  | Type  | Collation | Nullable | Default
----------+-------+-----------+----------+---------
 groname  | name  |           |          |
 grosysid | oid   |           |          |
 grolist  | oid[] |           |          |
    

Documentation: pg_group

pg_group (PostgreSQL 12)

            View "pg_catalog.pg_group"
  Column  | Type  | Collation | Nullable | Default
----------+-------+-----------+----------+---------
 groname  | name  |           |          |
 grosysid | oid   |           |          |
 grolist  | oid[] |           |          |
    

Documentation: pg_group

pg_group (PostgreSQL 11)

            View "pg_catalog.pg_group"
  Column  | Type  | Collation | Nullable | Default
----------+-------+-----------+----------+---------
 groname  | name  |           |          |
 grosysid | oid   |           |          |
 grolist  | oid[] |           |          |
    

Documentation: pg_group

pg_group (PostgreSQL 10)

            View "pg_catalog.pg_group"
  Column  | Type  | Collation | Nullable | Default
----------+-------+-----------+----------+---------
 groname  | name  |           |          |
 grosysid | oid   |           |          |
 grolist  | oid[] |           |          |
    

Documentation: pg_group

pg_group (PostgreSQL 9.6)

  View "pg_catalog.pg_group"
  Column  | Type  | Modifiers
----------+-------+-----------
 groname  | name  |
 grosysid | oid   |
 grolist  | oid[] |
    

Documentation: pg_group

pg_group (PostgreSQL 9.5)

  View "pg_catalog.pg_group"
  Column  | Type  | Modifiers
----------+-------+-----------
 groname  | name  |
 grosysid | oid   |
 grolist  | oid[] |
    

Documentation: pg_group

pg_group (PostgreSQL 9.4)

  View "pg_catalog.pg_group"
  Column  | Type  | Modifiers
----------+-------+-----------
 groname  | name  |
 grosysid | oid   |
 grolist  | oid[] |
    

Documentation: pg_group

pg_group (PostgreSQL 9.3)

  View "pg_catalog.pg_group"
  Column  | Type  | Modifiers
----------+-------+-----------
 groname  | name  |
 grosysid | oid   |
 grolist  | oid[] |
    

Documentation: pg_group

pg_group (PostgreSQL 9.2)

  View "pg_catalog.pg_group"
  Column  | Type  | Modifiers
----------+-------+-----------
 groname  | name  |
 grosysid | oid   |
 grolist  | oid[] |
    

Documentation: pg_group

pg_group (PostgreSQL 9.1)

  View "pg_catalog.pg_group"
  Column  | Type  | Modifiers
----------+-------+-----------
 groname  | name  |
 grosysid | oid   |
 grolist  | oid[] |
    

Documentation: pg_group

pg_group (PostgreSQL 9.0)

  View "pg_catalog.pg_group"
  Column  | Type  | Modifiers
----------+-------+-----------
 groname  | name  |
 grosysid | oid   |
 grolist  | oid[] |
    

Documentation: pg_group

pg_group (PostgreSQL 8.4)

  View "pg_catalog.pg_group"
  Column  | Type  | Modifiers
----------+-------+-----------
 groname  | name  |
 grosysid | oid   |
 grolist  | oid[] |
View definition:
 SELECT pg_authid.rolname AS groname, pg_authid.oid AS grosysid, ARRAY( SELECT pg_auth_members.member
           FROM pg_auth_members
          WHERE pg_auth_members.roleid = pg_authid.oid) AS grolist
   FROM pg_authid
  WHERE NOT pg_authid.rolcanlogin;
    

Documentation: pg_group

pg_group (PostgreSQL 8.3)

  View "pg_catalog.pg_group"
  Column  | Type  | Modifiers
----------+-------+-----------
 groname  | name  |
 grosysid | oid   |
 grolist  | oid[] |
View definition:
 SELECT pg_authid.rolname AS groname, pg_authid.oid AS grosysid, ARRAY( SELECT pg_auth_members.member
           FROM pg_auth_members
          WHERE pg_auth_members.roleid = pg_authid.oid) AS grolist
   FROM pg_authid
  WHERE NOT pg_authid.rolcanlogin;
    

Documentation: pg_group

pg_group (PostgreSQL 8.2)

  View "pg_catalog.pg_group"
  Column  | Type  | Modifiers
----------+-------+-----------
 groname  | name  |
 grosysid | oid   |
 grolist  | oid[] |
View definition:
 SELECT pg_authid.rolname AS groname, pg_authid.oid AS grosysid, ARRAY( SELECT pg_auth_members.member
           FROM pg_auth_members
          WHERE pg_auth_members.roleid = pg_authid.oid) AS grolist
   FROM pg_authid
  WHERE NOT pg_authid.rolcanlogin;
    

Documentation: pg_group

Change history

This view has not been modified since it was added in PostgreSQL 8.1.

Categories

System catalogue, User management

See also

pg_shadow, pg_auth_members