doc/src/sgml/ref/create_group.sgml

   1 <!--
   2 doc/src/sgml/ref/create_group.sgml
   3 PostgreSQL documentation
   4 -->
   5
   6 <refentry id="sql-creategroup">
   7  <indexterm zone="sql-creategroup">
   8   <primary>CREATE GROUP</primary>
   9  </indexterm>
  10
  11  <refmeta>
  12   <refentrytitle>CREATE GROUP</refentrytitle>
  13   <manvolnum>7</manvolnum>
  14   <refmiscinfo>SQL - Language Statements</refmiscinfo>
  15  </refmeta>
  16
  17  <refnamediv>
  18   <refname>CREATE GROUP</refname>
  19   <refpurpose>define a new database role</refpurpose>
  20  </refnamediv>
  21
  22  <refsynopsisdiv>
  23 <synopsis>
  24 CREATE GROUP <replaceable class="parameter">name</replaceable> [ [ WITH ] <replaceable class="parameter">option</replaceable> [ ... ] ]
  25
  26 <phrase>where <replaceable class="parameter">option</replaceable> can be:</phrase>
  27
  28       SUPERUSER | NOSUPERUSER
  29     | CREATEDB | NOCREATEDB
  30     | CREATEROLE | NOCREATEROLE
  31     | INHERIT | NOINHERIT
  32     | LOGIN | NOLOGIN
  33     | REPLICATION | NOREPLICATION
  34     | BYPASSRLS | NOBYPASSRLS
  35     | CONNECTION LIMIT <replaceable class="parameter">connlimit</replaceable>
  36     | [ ENCRYPTED ] PASSWORD '<replaceable class="parameter">password</replaceable>' | PASSWORD NULL
  37     | VALID UNTIL '<replaceable class="parameter">timestamp</replaceable>'
  38     | IN ROLE <replaceable class="parameter">role_name</replaceable> [, ...]
  39     | IN GROUP <replaceable class="parameter">role_name</replaceable> [, ...]
  40     | ROLE <replaceable class="parameter">role_name</replaceable> [, ...]
  41     | ADMIN <replaceable class="parameter">role_name</replaceable> [, ...]
  42     | USER <replaceable class="parameter">role_name</replaceable> [, ...]
  43     | SYSID <replaceable class="parameter">uid</replaceable>
  44 </synopsis>
  45  </refsynopsisdiv>
  46
  47  <refsect1>
  48   <title>Description</title>
  49
  50   <para>
  51    <command>CREATE GROUP</command> is now an alias for
  52    <xref linkend="sql-createrole"/>.
  53   </para>
  54  </refsect1>
  55
  56  <refsect1>
  57   <title>Compatibility</title>
  58
  59   <para>
  60    There is no <command>CREATE GROUP</command> statement in the SQL
  61    standard.
  62   </para>
  63  </refsect1>
  64
  65  <refsect1>
  66   <title>See Also</title>
  67
  68   <simplelist type="inline">
  69    <member><xref linkend="sql-createrole"/></member>
  70   </simplelist>
  71  </refsect1>
  72 </refentry>