CREATE_GROUP(7)

✨ 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 πŸ’–βœ¨