1CREATE GROUP()                   SQL Commands                   CREATE GROUP()
2
3
4

NAME

6       CREATE GROUP - define a new database role
7
8

SYNOPSIS

10       CREATE GROUP name [ [ WITH ] option [ ... ] ]
11
12       where option can be:
13
14             SUPERUSER | NOSUPERUSER
15           | CREATEDB | NOCREATEDB
16           | CREATEROLE | NOCREATEROLE
17           | CREATEUSER | NOCREATEUSER
18           | INHERIT | NOINHERIT
19           | LOGIN | NOLOGIN
20           | [ ENCRYPTED | UNENCRYPTED ] PASSWORD 'password'
21           | VALID UNTIL 'timestamp'
22           | IN ROLE rolename [, ...]
23           | IN GROUP rolename [, ...]
24           | ROLE rolename [, ...]
25           | ADMIN rolename [, ...]
26           | USER rolename [, ...]
27           | SYSID uid
28
29

DESCRIPTION

31       CREATE GROUP is now an alias for CREATE ROLE [create_role(7)].
32

COMPATIBILITY

34       There is no CREATE GROUP statement in the SQL standard.
35

SEE ALSO

37       CREATE ROLE [create_role(7)]
38
39
40
41SQL - Language Statements         2008-06-08                    CREATE GROUP()