↑↓ 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 7.1 reached end of support in April 2006. See the current version for supported releases.
PostgreSQL 7.1.3 Documentation
Prev Next

DROP GROUP

Name

DROP GROUP  --  Removes a group

Synopsis

DROP GROUP name

Inputs

name

The name of an existing group.

Outputs

DROP GROUP

The message returned if the group is successfully deleted.

Description

DROP GROUP removes the specified group from the database. The users in the group are not deleted.

Use CREATE GROUP to add new groups, and ALTER GROUP to change a group's membership.

Usage

To drop a group:

DROP GROUP staff;

Compatibility

SQL92

There is no DROP GROUP in SQL92.

Prev Home Next
DROP FUNCTION Up DROP INDEX

Report a documentation issue

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