CREATE_GROUP - define a new database role
Contents
Compatibility
There is no CREATEGROUP statement in the SQL standard.
Description
CREATEGROUP is now an alias for CREATE ROLE (CREATE_ROLE(7)).
Name
CREATE_GROUP - define a new database role
See Also
CREATE ROLE (CREATE_ROLE(7))
PostgreSQL 17.5 2025 CREATEGROUP(7)
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
