select open change scope Open full search

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

Supported versions: Current (18) / 17 / 16 / 15 / 14
Development versions: 19 / devel
Unsupported versions: 13 / 12 / 11 / 10 / 9.6 / 9.5 / 9.4 / 9.3 / 9.2 / 9.1 / 9.0 / 8.4 / 8.3 / 8.2 / 8.1 / 8.0 / 7.4 / 7.3 / 7.2 / 7.1
Historical version. PostgreSQL 8.0 reached end of support in October 2010. See the current version for supported releases.

DROP GROUP

Name

DROP GROUP -- remove a user group

Synopsis

DROP GROUP name

Description

DROP GROUP removes the specified group. The users in the group are not removed.

Parameters

name

The name of an existing group.

Notes

It is unwise to drop a group that has any granted permissions on objects. Currently, this is not enforced, but it is likely that future versions of PostgreSQL will check for the error.

Examples

To drop a group:

DROP GROUP staff;

Compatibility

There is no DROP GROUP statement in the SQL standard.

Report a documentation issue

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