PostgreSQL 8.1.5 Documentation
Prev	Fast Backward		Fast Forward	Next

CREATE GROUP

Name

CREATE GROUP -- define a new database role

Synopsis

CREATE GROUP 
name
 [ [ WITH ] 
option
 [ ... ] ]

where 
option
 can be:
    
      SUPERUSER | NOSUPERUSER
    | CREATEDB | NOCREATEDB
    | CREATEROLE | NOCREATEROLE
    | CREATEUSER | NOCREATEUSER
    | INHERIT | NOINHERIT
    | LOGIN | NOLOGIN
    | [ ENCRYPTED | UNENCRYPTED ] PASSWORD '
password
'
    | VALID UNTIL '
timestamp
' 
    | IN ROLE 
rolename
 [, ...]
    | IN GROUP 
rolename
 [, ...]
    | ROLE 
rolename
 [, ...]
    | ADMIN 
rolename
 [, ...]
    | USER 
rolename
 [, ...]
    | SYSID 
uid

Description

CREATE GROUP is now an alias for CREATE ROLE , which see for more information.

Compatibility

There is no CREATE GROUP statement in the SQL standard.

CREATE GROUP

Name

Synopsis

Description

Compatibility

See Also