CREATE_GROUP(7pg15)

👑 CREATE_GROUP — define a new database role

okay so real talk, bestie: this page is from the PostgreSQL 15.19 Documentation and it's honestly the shortest glow-up in the whole manual. but we're still gonna read it properly because that's just who we are 💅

---

✨ NAME ✨

CREATE_GROUP — define a new database role. that's it. that's the whole job. she's a group, she's a role, she contains multitudes 💖

---

🎀 SYNOPSIS 🎀

here's the whole shape of it, copy-paste this energy exactly:

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

and here's what option can be — literally all of them, no cap:

      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

and in list form, because some of us (me) need the vibe laid out 🦋:

• 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 name, option, connlimit, password, timestamp, role_name and uid up there is a placeholder — don't type the word "name" and then act surprised, iykyk 😭

---

🌸 DESCRIPTION 🌸

okay, the big reveal, and it's lowkey iconic: CREATE GROUP is now an alias for CREATE ROLE (that's CREATE_ROLE(7)). she changed her name, she's the same queen. main character energy all around 👑

fr fr though — if you were looking for the actual deep-dive on all those options, the docs are pointing you at CREATE_ROLE(7). this page is the alias page, not the lore page 🫶

---

🌈 COMPATIBILITY 🌈

there is no CREATE GROUP statement in the SQL standard. not a one. zero. nada. so if some other database is acting like this is standard behaviour, bestie, it's giving made-up 💀

---

⭐ SEE ALSO ⭐

• CREATE ROLE — CREATE_ROLE(7) — go here, this is where the real content lives 💜

---

and that's the whole page, short and sweet, we ate and left no crumbs 🍓

cute little sign-off: this was PostgreSQL 15.19, dated 2026 🎀 go forth and make roles, bestie 💖