CREATE_GROUP(7pg17)

πŸ“¦ version 17.11, in opensuse-leap 16.0

πŸ’– 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