—
NAME
CREATE_GROUP - define a new database role
SYNOPSIS
bash
CREATE GROUP \nname\n [ [ WITH ] \noption\n [ ... ] ]
where \noption\n can be:
\n
SUPERUSER | NOSUPERUSER
\n
| CREATEDB | NOCREATEDB
\n
| CREATEROLE | NOCREATEROLE
\n
| INHERIT | NOINHERIT
\n
| LOGIN | NOLOGIN
\n
| REPLICATION | NOREPLICATION
\n
| BYPASSRLS | NOBYPASSRLS
\n
| CONNECTION LIMIT \nconnlimit\n
\n
| [ ENCRYPTED ] PASSWORD '\npassword\n' | PASSWORD NULL
\n
| VALID UNTIL '\ntimestamp\n'
\n
| IN ROLE \nrole_name\n [, ...]
\n
| IN GROUP \nrole_name\n [, ...]
\n
| ROLE \nrole_name\n [, ...]
\n
| ADMIN \nrole_name\n [, ...]
\n
| USER \nrole_name\n [, ...]
\n
| SYSID \nuidDESCRIPTION
CREATE GROUP is now an alias for CREATE ROLE (CREATE_ROLE(7)).
COMPATIBILITY
There is no CREATE GROUP statement in the SQL standard.
SEE ALSO
CREATE ROLE (CREATE_ROLE(7))