granicus.if.org Git - postgresql/blob - 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  <refmeta>
   8   <refentrytitle>CREATE GROUP</refentrytitle>
   9   <manvolnum>7</manvolnum>
  10   <refmiscinfo>SQL - Language Statements</refmiscinfo>
  11  </refmeta>
  12
  13  <refnamediv>
  14   <refname>CREATE GROUP</refname>
  15   <refpurpose>define a new database role</refpurpose>
  16  </refnamediv>
  17
  18  <indexterm zone="sql-creategroup">
  19   <primary>CREATE GROUP</primary>
  20  </indexterm>
  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     | CREATEUSER | NOCREATEUSER
  32     | INHERIT | NOINHERIT
  33     | LOGIN | NOLOGIN
  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>
  42 </synopsis>
  43  </refsynopsisdiv>
  44
  45  <refsect1>
  46   <title>Description</title>
  47
  48   <para>
  49    <command>CREATE GROUP</command> is now an alias for
  50    <xref linkend="sql-createrole">.
  51   </para>
  52  </refsect1>
  53
  54  <refsect1>
  55   <title>Compatibility</title>
  56
  57   <para>
  58    There is no <command>CREATE GROUP</command> statement in the SQL
  59    standard.
  60   </para>
  61  </refsect1>
  62
  63  <refsect1>
  64   <title>See Also</title>
  65
  66   <simplelist type="inline">
  67    <member><xref linkend="sql-createrole"></member>
  68   </simplelist>
  69  </refsect1>
  70 </refentry>