DROP_USER(7)

💅 DROP USER(7) — the PostgreSQL glow-up page

okay bestie, welcome to the PostgreSQL 18.6 Documentation page for DROP USER ✨ it's short, it's sweet, it's basically the same girl as DROP ROLE wearing a different outfit 🎀

🌸 NAME 🌸

DROP USER — remove a database role 💖

✨ SYNOPSIS ✨

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

🦋 DESCRIPTION 🦋

so here's the tea ☕ DROP USER is simply an alternate spelling of DROP ROLE. that's it. that's the whole vibe. no cap, no secret extra behaviour, no hidden plot twist 🙈 same statement, same energy, different name — it's giving two nicknames for one main character 👑

💀 COMPATIBILITY 💀

the DROP USER statement is a PostgreSQL extension. the SQL standard is out here leaving the definition of users to the implementation, which lowkey means it just doesn't specify it at all 🫠 so yeah, this one's a PostgreSQL original, iykyk 💅

👀 SEE ALSO 👀

• DROP ROLE (DROP_ROLE(7)) — go read that one too, fr fr, it's the same thing but the ✨canonical✨ spelling 🫶

k byeeee, that's the whole page bestie!! 🌈⭐ this was PostgreSQL 18.6, dated 2026, from the DROP USER(7) manual page 💖🎀 go drop some roles (carefully, queen) 🧚🌸