CREATE_GROUP(7pg13)

🎀 CREATE GROUP (7) 🎀

ok so like — welcome to the CREATE GROUP page, bestie. this is a PostgreSQL 13 manual page (yep, the big one 💅), and honestly? it's a short one. a little snack. a bite-size lil entry. let's get into it ✨

---

💖 NAME 💖

CREATE_GROUP — define a new database role 🫶

✨ SYNOPSIS ✨

CREATE GROUP name [ [ WITH ] option [ ... ] ]

where option can be:

      SUPERUSER | NOSUPERUSER
    | CREATEDB | NOCREATEDB
    | CREATEROLE | NOCREATEROLE
    | INHERIT | NOINHERIT
    | LOGIN | NOLOGIN
    | REPLICATION | NOREPLICATION
    | BYPASSRLS | NOBYPASSRLS
    | CONNECTION LIMIT connlimit
    | [ ENCRYPTED ] PASSWORD 'password' | PASSWORD NULL
    | VALID UNTIL 'timestamp'
    | IN ROLE role_name [, ...]
    | IN GROUP role_name [, ...]
    | ROLE role_name [, ...]
    | ADMIN role_name [, ...]
    | USER role_name [, ...]
    | SYSID uid

like, look at all those options — she's got range 💅 every single one of them is listed up there, no gatekeeping, no cap. WITH is optional (square brackets, bestie), and you can stack as many options as you want.

🌸 DESCRIPTION 🌸

okay so here's the tea, and it's honestly kind of iconic: CREATE GROUP is now an alias for CREATE ROLE — the one and only CREATE_ROLE(7). 🎀

that's it. that's the description. she said "I'm a rebrand of a legend" and left. main character energy fr fr.

🦋 COMPATIBILITY 🦋

sooo... there is no CREATE GROUP statement in the SQL standard. 😭 not a single one. it's giving "we made this at home." so if you're out here vibe-checking your SQL against the standard, this ain't it — lowkey it's a PostgreSQL thing, not a standard thing.

💜 SEE ALSO 💜

• CREATE ROLE (CREATE_ROLE(7)) 👑 — the real one, the blueprint, the source material. go read her next.

---

ngl this whole page is basically a "see also" to CREATE ROLE, so if you're gonna do the thing, do the thing over there and take this page with you as the lil callback 🫶

---

and that's the vibe check! 🌈 this lil cutie of a page is from PostgreSQL 13.23, dated 2025 — CREATE GROUP(7), besties, signing off ✨💖🎀