Contents
DROP USER
An SQL command for removing a database role
DROP USER
is a DDL command for removing a database role.
DROP USER
was added in PostgreSQL 6.3; since PostgreSQL 8.1 it has been an alias for DROP ROLE
.
Change history
- PostgreSQL 8.2
DROP USER IF EXISTS ...
syntax added (commit f8b54fe6)
- PostgreSQL 8.1
- PostgreSQL 6.3
- added (commit 4c04f772)
Examples
Basic usage example for DROP USER
:
postgres=# DROP USER foo; DROP ROLE
Attempting to drop a role which does not exist:
postgres=# DROP USER foo; ERROR: role "foo" does not exist
Safely attempting to drop a role which might not exist:
postgres=# DROP USER IF EXISTS foo; NOTICE: role "foo" does not exist, skipping DROP ROLE
Note thas as DROP USER
is an alias for DROP ROLE
, output returned for this command references roles.
For more examples see DROP ROLE
.
References
- PostgreSQL documentation: DROP USER