CREATE_GROUP(7pg14)

💖 NAME 💖

okay bestie, this is CREATE GROUP(7) from the PostgreSQL 14.24 Documentation ✨ and the name is literally right here: CREATE_GROUP — define a new database role. that’s the vibe, no cap 🫶

✨ SYNOPSIS ✨

the whole spell goes like this:

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

every option up there is exactly as written — no extras, no invented flags, no “I fixed the spacing” nonsense 💅

🦋 DESCRIPTION 🦋

so CREATE GROUP is now an alias for CREATE ROLE (CREATE_ROLE(7)). that’s the whole tea ☕️ — it’s giving alias energy, and honestly? iconic.

🌈 COMPATIBILITY 🌈

bad news for the SQL-standard girlies 😭 there is no CREATE GROUP statement in the SQL standard. periodt.

🎀 SEE ALSO 🎀

• CREATE ROLE (CREATE_ROLE(7)) — the main character this alias points at 💜

PostgreSQL 14.24 · 2026 · CREATE GROUP(7) — mwah, bestie, go slay your roles 💋👑