PostgreSQL: Documentation: devel: DROP USER

September 25, 2025: PostgreSQL 18 Released!

Documentation → PostgreSQL devel (2025年09月25日 15:24:14 - git commit 507aa16125c)

Supported Versions: Current (18) / 17 / 16 / 15 / 14 / 13

Development Versions: devel

Unsupported versions: 12 / 11 / 10 / 9.6 / 9.5 / 9.4 / 9.3 / 9.2 / 9.1 / 9.0 / 8.4 / 8.3 / 8.2 / 8.1 / 8.0 / 7.4 / 7.3 / 7.2 / 7.1

This documentation is for an unsupported version of PostgreSQL.
You may want to view the same page for the current version, or one of the other supported versions listed above instead.

DROP USER
Prev	Up	SQL Commands	Home	Next

DROP USER

DROP USER — remove a database role

Synopsis

DROP USER [ IF EXISTS ] name [, ...]

Description

DROP USER is simply an alternate spelling of DROP ROLE.

Compatibility

The DROP USER statement is a PostgreSQL extension. The SQL standard leaves the definition of users to the implementation.

DROP USER

Synopsis

Description

Compatibility

See Also