2 doc/src/sgml/ref/create_group.sgml
3 PostgreSQL documentation
6 <refentry id="SQL-CREATEGROUP">
8 <refentrytitle>CREATE GROUP</refentrytitle>
9 <manvolnum>7</manvolnum>
10 <refmiscinfo>SQL - Language Statements</refmiscinfo>
14 <refname>CREATE GROUP</refname>
15 <refpurpose>define a new database role</refpurpose>
18 <indexterm zone="sql-creategroup">
19 <primary>CREATE GROUP</primary>
24 CREATE GROUP <replaceable class="PARAMETER">name</replaceable> [ [ WITH ] <replaceable class="PARAMETER">option</replaceable> [ ... ] ]
26 <phrase>where <replaceable class="PARAMETER">option</replaceable> can be:</phrase>
28 SUPERUSER | NOSUPERUSER
29 | CREATEDB | NOCREATEDB
30 | CREATEROLE | NOCREATEROLE
31 | CREATEUSER | NOCREATEUSER
34 | [ ENCRYPTED | UNENCRYPTED ] PASSWORD '<replaceable class="PARAMETER">password</replaceable>'
35 | VALID UNTIL '<replaceable class="PARAMETER">timestamp</replaceable>'
36 | IN ROLE <replaceable class="PARAMETER">role_name</replaceable> [, ...]
37 | IN GROUP <replaceable class="PARAMETER">role_name</replaceable> [, ...]
38 | ROLE <replaceable class="PARAMETER">role_name</replaceable> [, ...]
39 | ADMIN <replaceable class="PARAMETER">role_name</replaceable> [, ...]
40 | USER <replaceable class="PARAMETER">role_name</replaceable> [, ...]
41 | SYSID <replaceable class="PARAMETER">uid</replaceable>
46 <title>Description</title>
49 <command>CREATE GROUP</command> is now an alias for
50 <xref linkend="sql-createrole">.
55 <title>Compatibility</title>
58 There is no <command>CREATE GROUP</command> statement in the SQL
64 <title>See Also</title>
66 <simplelist type="inline">
67 <member><xref linkend="sql-createrole"></member>