CREATE_GROUP(7pg16)

💖 CREATE GROUP 💖

ok so real talk, bestie: this page is from the PostgreSQL 16.15 Documentation, and it's a tiny one — like, blink-and-you-miss-it tiny. But we're gonna read it together anyway because that's what friends do 🫶

---

✨ NAME ✨

CREATE_GROUP — define a new database role. that's the whole name section, she's short and she knows it 💅

---

🌸 SYNOPSIS 🌸

ok so here's the whole vibe, copied exactly so you don't have to squint at anything:

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 that menu 🔥 every single toggle is right there: SUPERUSER / NOSUPERUSER, CREATEDB / NOCREATEDB, CREATEROLE / NOCREATEROLE, INHERIT / NOINHERIT, LOGIN / NOLOGIN, REPLICATION / NOREPLICATION, BYPASSRLS / NOBYPASSRLS, plus 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 [, ...], and SYSID uid. iconic, no notes 👑

ngl this page doesn't define any of those for you — that's the other page's job (see SEE ALSO, she's down there 👇). don't come for me, I'm just the messenger 💀

---

🦋 DESCRIPTION 🦋

ok here's the tea, and it's honestly the shortest tea ever ☕

CREATE GROUP is now an alias for CREATE ROLE (CREATE_ROLE(7)).

that's it. that's the description. she said "I'm a rebrand, go read the real one." and honestly? respect. 🌈

---

🎀 COMPATIBILITY 🎀

There is no CREATE GROUP statement in the SQL standard.

so like... the SQL standard has never heard of her 😭 not a single line. this is a PostgreSQL-only situation, iykyk.

---

⭐ SEE ALSO ⭐

• CREATE ROLE (CREATE_ROLE(7)) — the main character 💖 go read this one, fr fr, because CREATE GROUP is literally just her alias.

---

and that's the whole page, bestie 🧚 you read it, you slayed it, periodt ✨

💜 signed, sealed, delivered: PostgreSQL 16.15, dated 2026 — see you at the next man page, mwah 💋 🎀