Movatterモバイル変換

CREATE GROUP

CREATE GROUP — define a new database role

Synopsis

CREATE GROUPname [ [ WITH ]option [ ... ] ]whereoption can be:      SUPERUSER | NOSUPERUSER    | CREATEDB | NOCREATEDB    | CREATEROLE | NOCREATEROLE    | INHERIT | NOINHERIT    | LOGIN | NOLOGIN    | REPLICATION | NOREPLICATION    | BYPASSRLS | NOBYPASSRLS    | CONNECTION LIMITconnlimit    | [ ENCRYPTED ] PASSWORD 'password' | PASSWORD NULL    | VALID UNTIL 'timestamp'    | IN ROLErole_name [, ...]    | IN GROUProle_name [, ...]    | ROLErole_name [, ...]    | ADMINrole_name [, ...]    | USERrole_name [, ...]    | SYSIDuid

Description

CREATE GROUP is now an alias forCREATE ROLE.

Compatibility

There is noCREATE GROUP statement in the SQL standard.

See Also