DROP USER - remove a database role
DROP USER [ IF EXISTS ] name [, ...]
DROP USER is now an alias for DROP ROLE [drop_role(7)].
The DROP USER statement is a PostgreSQL extension. The SQL standard leaves the definition of users to the implementation.
DROP ROLE [drop_role(7)]