DROP USER is a DDL command for removing a database role.
DROP USER execution:
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