~ubuntu-branches/ubuntu/oneiric/postgresql-9.1/oneiric-security

« back to all changes in this revision

Viewing changes to doc/src/sgml/man7/CREATE_GROUP.7

  • Committer: Bazaar Package Importer
  • Author(s): Martin Pitt
  • Date: 2011-05-11 10:41:53 UTC
  • Revision ID: james.westby@ubuntu.com-20110511104153-psbh2o58553fv1m0
Tags: upstream-9.1~beta1
ImportĀ upstreamĀ versionĀ 9.1~beta1

Show diffs side-by-side

added added

removed removed

Lines of Context:
 
1
'\" t
 
2
.\"     Title: CREATE GROUP
 
3
.\"    Author: The PostgreSQL Global Development Group
 
4
.\" Generator: DocBook XSL Stylesheets v1.75.1 <http://docbook.sf.net/>
 
5
.\"      Date: 2011-04-27
 
6
.\"    Manual: PostgreSQL 9.1beta1 Documentation
 
7
.\"    Source: PostgreSQL 9.1beta1
 
8
.\"  Language: English
 
9
.\"
 
10
.TH "CREATE GROUP" "7" "2011-04-27" "PostgreSQL 9.1beta1" "PostgreSQL 9.1beta1 Documentation"
 
11
.\" -----------------------------------------------------------------
 
12
.\" * set default formatting
 
13
.\" -----------------------------------------------------------------
 
14
.\" disable hyphenation
 
15
.nh
 
16
.\" disable justification (adjust text to left margin only)
 
17
.ad l
 
18
.\" -----------------------------------------------------------------
 
19
.\" * MAIN CONTENT STARTS HERE *
 
20
.\" -----------------------------------------------------------------
 
21
.SH "NAME"
 
22
CREATE_GROUP \- define a new database role
 
23
.\" CREATE GROUP
 
24
.SH "SYNOPSIS"
 
25
.sp
 
26
.nf
 
27
CREATE GROUP \fIname\fR [ [ WITH ] \fIoption\fR [ \&.\&.\&. ] ]
 
28
 
 
29
where \fIoption\fR can be:
 
30
 
 
31
      SUPERUSER | NOSUPERUSER
 
32
    | CREATEDB | NOCREATEDB
 
33
    | CREATEROLE | NOCREATEROLE
 
34
    | CREATEUSER | NOCREATEUSER
 
35
    | INHERIT | NOINHERIT
 
36
    | LOGIN | NOLOGIN
 
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 [, \&.\&.\&.]
 
44
    | SYSID \fIuid\fR
 
45
.fi
 
46
.SH "DESCRIPTION"
 
47
.PP
 
48
CREATE GROUP
 
49
is now an alias for
 
50
CREATE ROLE (\fBCREATE_ROLE\fR(7))\&.
 
51
.SH "COMPATIBILITY"
 
52
.PP
 
53
There is no
 
54
CREATE GROUP
 
55
statement in the SQL standard\&.
 
56
.SH "SEE ALSO"
 
57
CREATE ROLE (\fBCREATE_ROLE\fR(7))