manpagez: man pages & more
man create_group(l)
Home | html | info | man
CREATE GROUP()                   SQL Commands                   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 [create_role(l)].


COMPATIBILITY

       There is no CREATE GROUP statement in the SQL standard.


SEE ALSO

       CREATE ROLE [create_role(l)]



SQL - Language Statements         2008-09-19                    CREATE GROUP()

postgresql 8.3.4 - Generated Thu Oct 2 10:08:43 CDT 2008
© manpagez.com 2000-2024
Individual documents may contain additional copyright information.