Ubuntu manuals

Provided by: postgresql-client-8.0_8.0.7-2build1_i386

NAME

       CREATE GROUP - define a new user group

SYNOPSIS

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

       where option can be:

            SYSID gid
          | USER  username [, ...]

DESCRIPTION

       CREATE  GROUP will create a new group of users.  You must be a database
       superuser to use this command.

       Note that both users and groups are defined  at  the  database  cluster
       level, and so are valid in all databases in the cluster.

       Use  ALTER  GROUP  [alter_group(7)] to change a group’s membership, and
       DROP GROUP [drop_group(7)] to remove a group.

PARAMETERS

       name   The name of the group.

       gid    The SYSID clause can be used to choose the PostgreSQL  group  ID
              of  the  new  group.  This is normally not necessary, but may be
              useful if you  need  to  recreate  a  group  referenced  in  the
              permissions of some object.

              If this is not specified, the highest assigned group ID plus one
              (with a minimum of 100) will be used as default.

       username
              A list of users to include in the group. The users must  already
              exist.

EXAMPLES

       Create an empty group:

       CREATE GROUP staff;

       Create a group with members:

       CREATE GROUP marketing WITH USER jonathan, david;

COMPATIBILITY

       There  is  no  CREATE  GROUP  statement  in the SQL standard. Roles are
       similar in concept to groups.

SEE ALSO

       ALTER GROUP [alter_group(7)], DROP GROUP [drop_group(l)]