Remove a database role
DROP GROUP [ IF EXISTS ] name [, ...]
DROP GROUP is now an alias for DROP ROLE (DROP_ROLE(7)).
There is no DROP GROUP statement in the SQL standard.
DROP ROLE (DROP_ROLE(7))