CREATE_GROUP(7pg17)
π CREATE GROUP(7) β the PostgreSQL 17.11 glow-up π
okay so bestie, real talk: you're looking at the CREATE GROUP page from the PostgreSQL 17.11 docs, and it's honestly a short one β but we're gonna make it iconic anyway π
β¨ NAME β¨
CREATE_GROUP β define a new database role π«Ά
πΈ SYNOPSIS πΈ
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, yes, that's a lot of options β copy it exactly, don't freestyle it, i'm begging π
π DESCRIPTION π
okay so here's the tea: CREATE GROUP is now basically just an alias for CREATE ROLE (CREATE_ROLE(7)). that's it. that's the whole plot π
literally β same energy, different name. so if you want the real lore, go read CREATE_ROLE(7), because this page is giving "rebrand" and not much else π
π COMPATIBILITY π
ngl, the SQL standard has no CREATE GROUP statement. none. zero. not a single one. so if you're out here expecting standard compliance, bestieβ¦ no π
π¦ SEE ALSO π¦
CREATE ROLE(CREATE_ROLE(7)) β the main character this whole page is pointing at β
ok quick vibe check: nothing here is dangerous, deprecated, or undefined β it's just a cute little alias. but fr fr, if you need the actual option behaviour, CREATE_ROLE(7) is where you live now π«Ά
and that's the whole page, bestie β no cap π§ this lil doc came to you from PostgreSQL 17.11, dated 2026 β mwah, slay, periodt ππ
π¦ where this page comes from
- opensuse-leap 16.0: postgresql17 17.11-160000.1.1 Β· PostgreSQL
- opensuse-leap 16.0: postgresql17 17.11-160000.1.1 Β· PostgreSQL
- opensuse-leap 16.0: postgresql17 17.11-160000.1.1 Β· PostgreSQL
- opensuse-leap 16.0: postgresql17 17.11-160000.1.1 Β· PostgreSQL
- π girlified by deepseek-ai/DeepSeek-V4.1-Flash-1017 on : a language model's rewrite of the original, under its terms