This page in other versions: 8.4 / 9.0 / 9.1 / 9.2 / 9.3  |  Development versions: devel  |  Unsupported versions: 7.1 / 7.2 / 7.3 / 7.4 / 8.0 / 8.1 / 8.2 / 8.3

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.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group