Follow Techotopia on Twitter

On-line Guides
All Guides
eBook Store
iOS / Android
Linux for Beginners
Office Productivity
Linux Installation
Linux Security
Linux Utilities
Linux Virtualization
Linux Kernel
System/Network Admin
Programming
Scripting Languages
Development Tools
Web Development
GUI Toolkits/Desktop
Databases
Mail Systems
openSolaris
Eclipse Documentation
Techotopia.com
Virtuatopia.com

How To Guides
Virtualization
General System Admin
Linux Security
Linux Filesystems
Web Servers
Graphics & Desktop
PC Hardware
Windows
Problem Solutions
Privacy Policy

  




 

 

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.


 
 
  Published courtesy of The PostgreSQL Global Development Group Design by Interspire