dropuser

Drop a user

$ dropuser [username]

$ dropuser -i [username]

$ dropuser -h [hostname] [username]

$ dropuser -U [admin_user] [username]

$ dropuser --if-exists [username]

dropuser [options] username

dropuser removes a PostgreSQL user (role). It's a command-line wrapper around the DROP ROLE SQL statement, simplifying user management without requiring psql.
The role being dropped must not own any databases or have dependencies. Objects owned by the role should be reassigned or dropped before removing the user.
Only superusers and roles with CREATEROLE privilege can drop other roles.

USERNAME

PostgreSQL role/user to drop.

Server hostname.

Server port.

Connect as this user.

Prompt for confirmation.

Don't error if user doesn't exist.

Show SQL command executed.

Display help information.

Cannot drop role with dependencies. Role must not own objects. Requires appropriate privileges. Cannot drop current user or superuser without superuser rights.

dropuser is part of PostgreSQL client utilities, complementing createuser for command-line user management. It has been available since early PostgreSQL versions.

createuser(1), psql(1), dropdb(1)