DROP_GROUP(7pg14)

πŸ“¦ version 14.24, in opensuse-leap 16.0

πŸ’… 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