12th September 2019: PostgreSQL 12 Beta 4 Released!
Supported Versions: Current (11) / 10 / 9.6 / 9.5 / 9.4
Development Versions: 12 / devel
Unsupported versions: 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
This documentation is for an unsupported version of PostgreSQL.
You may want to view the same page for the current version, or one of the supported versions listed above instead.

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.