DROP_GROUP(7pg16)

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

πŸ’… DROP GROUP πŸ’…

okay so bestie, welcome to the DROP GROUP page from the PostgreSQL 16.15 Documentation β€” yes that's the manual name, we're folding it in right here at the top so you're oriented, you're welcome 🫢. This is DROP GROUP(7) and she's short, she's sweet, and she's honestly a little iconic for how little she has to say.


✨ NAME ✨

DROP_GROUP β€” remove a database role πŸŽ€

like, literally just yeet a role out of existence. that's the whole job.


πŸ¦‹ SYNOPSIS πŸ¦‹

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

okay so the way that this reads β€” you got your DROP GROUP, you got an optional IF EXISTS (the "don't yell at me if it's not there" button, lowkey a lifesaver 😭), and then name [, ...] which means one name, or a bunch separated by commas, fr fr. multiple at once, she's efficient πŸ’…


🌸 DESCRIPTION 🌸

okay so here's the tea πŸ“: DROP GROUP is now an alias for DROP ROLE.

that's it. that's the description. she's not doing her own thing anymore, she's just DROP ROLE wearing a different little outfit ✨. so if you're looking for the real, full, main-character explanation of what happens when you drop a role, you gotta go read that page (see SEE ALSO below, i gotchu πŸ‘‘).


🌈 COMPATIBILITY 🌈

ngl, there is no DROP GROUP statement in the SQL standard. like at all. zero. the standard said "not me knowing her" πŸ’€ so this is a PostgreSQL thing, not a universal thing. keep that in mind if you're porting stuff around, iykyk.


🧚 SEE ALSO 🧚

  • DROP ROLE (DROP_ROLE(7)) β€” the actual real one, the source material, the blueprint, go read it bestie πŸ”₯

πŸ’œ friendly reminder that DROP GROUP being an alias for DROP ROLE means the semantics are DROP ROLE's semantics β€” so please read DROP_ROLE(7) before you go dropping anything, okay? dropping things is permanent energy and we respect that πŸ™ˆ

mwah πŸ’– that's the whole page! brought to you by PostgreSQL 16.15, dated 2026, and this little rewrite is signed off with a slay, stay schemin', and always read your SEE ALSOs πŸŒŸπŸ’…πŸ¦‹

πŸ“¦ where this page comes from