DROP_GROUP(7pg14)
π DROP_GROUP π
okay so real talk, this little page lives in the PostgreSQL 14.24 Documentation and it's honestly so short it's giving "one-line text from your bestie at 2am" energy π«Ά but it's important, so let's go.
β¨ NAME β¨
DROP_GROUP β remove a database role π
like, yeet a role out of existence. that's the whole vibe check.
πΈ SYNOPSIS πΈ
DROP GROUP [ IF EXISTS ] name [, ...]
ok so you got the optional IF EXISTS (which is your "please don't scream at me if it's not there" flag, bestie π), and then one or more names, separated by commas, because you can absolutely drop a whole squad at once. periodt.
π¦ DESCRIPTION π¦
DROP GROUP is now an alias for DROP ROLE.
that's it. that's the whole description. not me being dramatic over here π but fr fr, this is the historical name β it's literally just DROP ROLE wearing a different outfit now. same icon, different era π
so if you're reading this thinking "wait, isn't this just DROP ROLE?" β yes queen, you clocked it π
π COMPATIBILITY π
there is no DROP GROUP statement in the SQL standard.
ngl, the SQL standard simply did not include this one. so don't go expecting it to be portable β it's a PostgreSQL thing, iykyk π€·ββοΈ
β SEE ALSO β
DROP ROLE(DROP_ROLE(7)) β the main character this page keeps pointing at π
and that's the whole page, bestie. short, sweet, and absolutely ate π
lowkey a reminder: this thing is an alias now, so the real lore lives in DROP_ROLE(7) β go read that one for the actual details, fr fr π§
mwah π stay hydrated and may your roles always drop cleanly
PostgreSQL 14.24 Β· 2026 Β· DROP GROUP(7) β signed off with love by your favorite Unix gremlin πβ¨
π¦ where this page comes from
- opensuse-leap 16.0: postgresql14 14.24-160000.1.1 Β· PostgreSQL
- opensuse-leap 16.0: postgresql14 14.24-160000.1.1 Β· PostgreSQL
- opensuse-leap 16.0: postgresql14 14.24-160000.1.1 Β· PostgreSQL
- opensuse-leap 16.0: postgresql14 14.24-160000.1.1 Β· PostgreSQL
- π girlified by deepseek-ai/DeepSeek-V4.1-Flash-1017 on : a language model's rewrite of the original, under its terms