2
.\" Title: CREATE GROUP
3
.\" Author: The PostgreSQL Global Development Group
4
.\" Generator: DocBook XSL Stylesheets v1.75.1 <http://docbook.sf.net/>
6
.\" Manual: PostgreSQL 9.1beta1 Documentation
7
.\" Source: PostgreSQL 9.1beta1
10
.TH "CREATE GROUP" "7" "2011-04-27" "PostgreSQL 9.1beta1" "PostgreSQL 9.1beta1 Documentation"
11
.\" -----------------------------------------------------------------
12
.\" * set default formatting
13
.\" -----------------------------------------------------------------
14
.\" disable hyphenation
16
.\" disable justification (adjust text to left margin only)
18
.\" -----------------------------------------------------------------
19
.\" * MAIN CONTENT STARTS HERE *
20
.\" -----------------------------------------------------------------
22
CREATE_GROUP \- define a new database role
27
CREATE GROUP \fIname\fR [ [ WITH ] \fIoption\fR [ \&.\&.\&. ] ]
29
where \fIoption\fR can be:
31
SUPERUSER | NOSUPERUSER
32
| CREATEDB | NOCREATEDB
33
| CREATEROLE | NOCREATEROLE
34
| CREATEUSER | NOCREATEUSER
37
| [ ENCRYPTED | UNENCRYPTED ] PASSWORD \(aq\fIpassword\fR\(aq
38
| VALID UNTIL \(aq\fItimestamp\fR\(aq
39
| IN ROLE \fIrole_name\fR [, \&.\&.\&.]
40
| IN GROUP \fIrole_name\fR [, \&.\&.\&.]
41
| ROLE \fIrole_name\fR [, \&.\&.\&.]
42
| ADMIN \fIrole_name\fR [, \&.\&.\&.]
43
| USER \fIrole_name\fR [, \&.\&.\&.]
50
CREATE ROLE (\fBCREATE_ROLE\fR(7))\&.
55
statement in the SQL standard\&.
57
CREATE ROLE (\fBCREATE_ROLE\fR(7))