CREATE_GROUP(7pg18)

✨ NAME ✨

okay so bestie, welcome to the CREATE_GROUP(7) page from the PostgreSQL 18.6 Documentation — and literally this one is short and sweet. it's giving "i'm just here to define a new database role" energy.

• CREATE_GROUP — define a new database role 💖

---

🌸 SYNOPSIS 🌸

here's the whole vibe, copy-paste ready:

       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

---

💖 DESCRIPTION 💖

so the tea is: CREATE GROUP is now an alias for CREATE ROLE (CREATE_ROLE(7)). that's it. that's the whole description. like, they're the same thing now, so go read that page for the full scoop. 💅

---

🦋 COMPATIBILITY 🦋

ngl bestie, there is no CREATE GROUP statement in the SQL standard. not a single one. it's simply not there. periodt. 💀

---

👑 SEE ALSO 👑

• CREATE ROLE (CREATE_ROLE(7)) — the main character, the blueprint, the one you actually wanna read. 🫶

---

PostgreSQL 18.6 • 2026 • CREATE GROUP(7) — stay slay, bestie 💖✨