Home Explore Blog CI



postgresql

4th chunk of `doc/src/sgml/ref/createuser.sgml`
b567107b39c98ad5c58deec50413c4b75ffc80454e391d1a0000000100000fa2
 <term><option>--superuser</option></term>
      <listitem>
       <para>
        The new user will be a superuser.
       </para>
      </listitem>
     </varlistentry>

     <varlistentry>
      <term><option>-S</option></term>
      <term><option>--no-superuser</option></term>
      <listitem>
       <para>
        The new user will not be a superuser.  This is the default.
       </para>
      </listitem>
     </varlistentry>

     <varlistentry>
      <term><option>-v <replaceable class="parameter">timestamp</replaceable></option></term>
      <term><option>--valid-until=<replaceable class="parameter">timestamp</replaceable></option></term>
      <listitem>
       <para>
        Set a date and time after which the role's password is no longer valid.
        The default is to set no password expiry date.
       </para>
      </listitem>
     </varlistentry>

     <varlistentry>
       <term><option>-V</option></term>
       <term><option>--version</option></term>
       <listitem>
       <para>
       Print the <application>createuser</application> version and exit.
       </para>
       </listitem>
     </varlistentry>

     <varlistentry>
      <term><option>--bypassrls</option></term>
      <listitem>
       <para>
        The new user will bypass every row-level security (RLS) policy.
       </para>
      </listitem>
     </varlistentry>

     <varlistentry>
      <term><option>--no-bypassrls</option></term>
      <listitem>
       <para>
        The new user will not bypass row-level security (RLS) policies.  This is
        the default.
       </para>
      </listitem>
     </varlistentry>

     <varlistentry>
      <term><option>--replication</option></term>
      <listitem>
       <para>
        The new user will have the <literal>REPLICATION</literal> privilege,
        which is described more fully in the documentation for <xref
        linkend="sql-createrole"/>.
       </para>
      </listitem>
     </varlistentry>

     <varlistentry>
      <term><option>--no-replication</option></term>
      <listitem>
       <para>
        The new user will not have the <literal>REPLICATION</literal>
        privilege, which is described more fully in the documentation for <xref
        linkend="sql-createrole"/>.  This is the default.
       </para>
      </listitem>
     </varlistentry>

     <varlistentry>
       <term><option>-?</option></term>
       <term><option>--help</option></term>
       <listitem>
       <para>
       Show help about <application>createuser</application> command line
       arguments, and exit.
       </para>
       </listitem>
     </varlistentry>

    </variablelist>
  </para>

  <para>
   <application>createuser</application> also accepts the following
   command-line arguments for connection parameters:

   <variablelist>
     <varlistentry>
      <term><option>-h <replaceable class="parameter">host</replaceable></option></term>
      <term><option>--host=<replaceable class="parameter">host</replaceable></option></term>
      <listitem>
       <para>
        Specifies the host name of the machine on which the
        server
        is running.  If the value begins with a slash, it is used
        as the directory for the Unix domain socket.
       </para>
      </listitem>
     </varlistentry>

     <varlistentry>
      <term><option>-p <replaceable class="parameter">port</replaceable></option></term>
      <term><option>--port=<replaceable class="parameter">port</replaceable></option></term>
      <listitem>
       <para>
        Specifies the TCP port or local Unix domain socket file
        extension on which the server
        is listening for connections.
       </para>
      </listitem>
     </varlistentry>

     <varlistentry>
      <term><option>-U <replaceable class="parameter">username</replaceable></option></term>
      <term><option>--username=<replaceable class="parameter">username</replaceable></option></term>
      <listitem>
       <para>
        User name to connect as (not the

Title: createuser Options (Continued) and Connection Parameters
Summary
This section details the remaining options for the `createuser` command, including setting superuser status, password validity, displaying the version, bypassing/not bypassing row-level security, and granting/revoking replication privileges. It also describes command-line arguments for connection parameters such as host and port.