DROP GROUP

A DDL command for removing a database role

DROP GROUP is a DDL command for removing a database role.

DROP GROUP was added in PostgreSQL 7.0; since PostgreSQL 8.1 it has been an alias for DROP ROLE.

Change history

Basic DROP GROUP execution:

postgres=# DROP GROUP foo;
DROP ROLE

Attempting to drop a role which does not exist:

postgres=# DROP GROUP foo;
ERROR:  role "foo" does not exist

Safely attempting to drop a role which might not exist:

postgres=# DROP GROUP IF EXISTS foo;
NOTICE:  role "foo" does not exist, skipping
DROP ROLE

Note thas as DROP GROUP is an alias for DROP ROLE, output returned for this command references roles.

For more examples see DROP ROLE.