DROP_GROUP(7pg16)
π 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 thatDROP GROUPbeing an alias forDROP ROLEmeans the semantics areDROP ROLE's semantics β so please readDROP_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
- opensuse-leap 16.0: postgresql16 16.15-160000.1.1 Β· PostgreSQL
- opensuse-leap 16.0: postgresql16 16.15-160000.1.1 Β· PostgreSQL
- opensuse-leap 16.0: postgresql16 16.15-160000.1.1 Β· PostgreSQL
- opensuse-leap 16.0: postgresql16 16.15-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