select open change scope Open full search

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

Unsupported versions: 8.0 / 7.4 / 7.3 / 7.2 / 7.1
Historical version. PostgreSQL 7.1 reached end of support in April 2006. See the current manual for supported releases.

7.2. Groups

As in Unix, groups are a way of logically grouping users. To create a group, use

CREATE GROUP name
To add users to or remove users from a group, respectively, user
ALTER GROUP name ADD USER uname1, ...
ALTER GROUP name DROP USER uname1, ...

Report a documentation issue

Read the upstream documentation. For corrections, first check the current manual.