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
