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 πβ¨
π¦ where this page comes from
- alpine 3.23: postgresql18-doc 18.6-r0 Β· PostgreSQL
- alpine 3.24: postgresql18-doc 18.6-r0 Β· PostgreSQL
- arch rolling: postgresql 18.6-4 Β· PostgreSQL
- fedora 43: postgresql 18.6-1.fc43 Β· PostgreSQL
- fedora 43: postgresql 18.6-1.fc43 Β· PostgreSQL
- fedora 44: postgresql 18.6-1.fc44 Β· PostgreSQL
- fedora 44: postgresql 18.6-1.fc44 Β· PostgreSQL
- nixos 26.05: postgresql 18.6
- ubuntu resolute: postgresql-client-18 18.6-0ubuntu0.26.04.1 Β· PostgreSQL
- ubuntu stonking: postgresql-client-18 18.6-3build2 Β· PostgreSQL
- π girlified by deepseek-ai/DeepSeek-V4.1-Flash on : a language model's rewrite of the original, under its terms