17.3. Groups

As in Unix, groups are a way of logically grouping users to ease management of privileges: privileges can be granted to, or revoked from, a group as a whole. To create a group, use the CREATE GROUP SQL command:

CREATE GROUP name;

To add users to or remove users from an existing group, use ALTER GROUP:

ALTER GROUP name ADD USER uname1, ... ;
ALTER GROUP name DROP USER uname1, ... ;

To destroy a group, use DROP GROUP:

DROP GROUP name;

This only drops the group, not its member users.

To determine the set of existing groups, examine the pg_group system catalog, for example

SELECT groname FROM pg_group;

The psql program's \dg meta-command is also useful for listing the existing groups.