1CREATE GROUP(7) SQL Commands CREATE GROUP(7)
2
3
4
6 CREATE GROUP - define a new database role
7
8
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
31 CREATE GROUP is now an alias for CREATE ROLE [create_role(7)].
32
34 There is no CREATE GROUP statement in the SQL standard.
35
37 CREATE ROLE [create_role(7)]
38
39
40
41SQL - Language Statements 2011-09-22 CREATE GROUP(7)