Home • Explore • Blog • CI
☰



postgresql
2nd chunk of `doc/src/sgml/ref/createdb.sgml`
5df9e2b0047c8133b1c069f37e271e3b9c41cd2dbd08a12b0000000100000fa2
 <term><option>--echo</option></term>
      <listitem>
       <para>
        Echo the commands that <application>createdb</application> generates
        and sends to the server.
       </para>
      </listitem>
     </varlistentry>

     <varlistentry>
      <term><option>-E <replaceable class="parameter">encoding</replaceable></option></term>
      <term><option>--encoding=<replaceable class="parameter">encoding</replaceable></option></term>
      <listitem>
       <para>
        Specifies the character encoding scheme to be used in this
        database. The character sets supported by the
        <productname>PostgreSQL</productname> server are described in
        <xref linkend="multibyte-charset-supported"/>.
       </para>
      </listitem>
     </varlistentry>

     <varlistentry>
      <term><option>-l <replaceable class="parameter">locale</replaceable></option></term>
      <term><option>--locale=<replaceable class="parameter">locale</replaceable></option></term>
      <listitem>
       <para>
        Specifies the locale to be used in this database.  This is equivalent
        to specifying <option>--lc-collate</option>,
        <option>--lc-ctype</option>, and <option>--icu-locale</option> to the
        same value. Some locales are only valid for ICU and must be set with
        <option>--icu-locale</option>.
       </para>
      </listitem>
     </varlistentry>

     <varlistentry>
      <term><option>--lc-collate=<replaceable class="parameter">locale</replaceable></option></term>
      <listitem>
       <para>
        Specifies the LC_COLLATE setting to be used in this database.
       </para>
      </listitem>
     </varlistentry>

     <varlistentry>
      <term><option>--lc-ctype=<replaceable class="parameter">locale</replaceable></option></term>
      <listitem>
       <para>
        Specifies the LC_CTYPE setting to be used in this database.
       </para>
      </listitem>
     </varlistentry>

     <varlistentry>
      <term><option>--builtin-locale=<replaceable class="parameter">locale</replaceable></option></term>
      <listitem>
       <para>
        Specifies the locale name when the builtin provider is used. Locale support
        is described in <xref linkend="locale"/>.
       </para>
      </listitem>
     </varlistentry>

     <varlistentry>
      <term><option>--icu-locale=<replaceable class="parameter">locale</replaceable></option></term>
      <listitem>
       <para>
        Specifies the ICU locale ID to be used in this database, if the
        ICU locale provider is selected.
       </para>
      </listitem>
     </varlistentry>

     <varlistentry>
      <term><option>--icu-rules=<replaceable class="parameter">rules</replaceable></option></term>
      <listitem>
       <para>
        Specifies additional collation rules to customize the behavior of the
        default collation of this database.  This is supported for ICU only.
       </para>
      </listitem>
     </varlistentry>

     <varlistentry>
      <term><option>--locale-provider={<literal>builtin</literal>|<literal>libc</literal>|<literal>icu</literal>}</option></term>
      <listitem>
       <para>
        Specifies the locale provider for the database's default collation.
       </para>
      </listitem>
     </varlistentry>

     <varlistentry>
      <term><option>-O <replaceable class="parameter">owner</replaceable></option></term>
      <term><option>--owner=<replaceable class="parameter">owner</replaceable></option></term>
      <listitem>
       <para>
        Specifies the database user who will own the new database.
        (This name is processed as a double-quoted identifier.)
       </para>
      </listitem>
     </varlistentry>

     <varlistentry>
      <term><option>-S <replaceable class="parameter">strategy</replaceable></option></term>
      <term><option>--strategy=<replaceable class="parameter">strategy</replaceable></option></term>
      <listitem>
       <para>
        Specifies the database creation strategy.
Title: createdb Options: Encoding, Locale, Owner, and Strategy
Summary
This section details command-line options for `createdb`, including specifying the encoding scheme (`-E` or `--encoding`), locale settings (`-l` or `--locale`, `--lc-collate`, `--lc-ctype`, `--builtin-locale`, `--icu-locale`, `--icu-rules`, `--locale-provider`), database owner (`-O` or `--owner`), and database creation strategy (`-S` or `--strategy`).