CREATE GROUP - Creates a new group
SYNOPSIS
CREATE GROUP name
[ WITH
[ SYSID gid ]
[ USER username [, ...] ] ]
INPUTS
name The name of the group.
gid The SYSID clause can be used to choose the Postgres
group id of the new group. It is not necessary to
do so, however.
If this is not specified, the highest assigned
group id plus one, starting at 1, will be used as
default.
username
A list of users to include in the group. The users
must already exist.
OUTPUTS
CREATE GROUP
Message returned if the command completes success
fully.
DESCRIPTION
CREATE GROUP will create a new group in the database
installation. Refer to the adminstrator's guide for
information about using groups for authentication. You
must be a database superuser to use this command.
Use ALTER GROUP [alter_group(l)] to change a group's mem
bership, and DROP GROUP [drop_group(l)] to remove a group.
USAGE
Create an empty group:
CREATE GROUP staff
Create a group with members:
CREATE GROUP marketing WITH USER jonathan, david
SQL92
There is no CREATE GROUP statement in SQL92. Roles are
similar in concept to groups.
Man(1) output converted with
man2html