<!--

$Header: /cvsroot/pgsql/doc/src/sgml/ref/createdb.sgml,v 1.16 2000/12/25 23:15:26 petere Exp $

$Header: /cvsroot/pgsql/doc/src/sgml/ref/createdb.sgml,v 1.17 2001/02/18 17:53:54 tgl Exp $

Postgres documentation

-->

Specifies the hostname of the machine on which the

<application>postmaster</application>

is running. If host begins with a slash, it is used

as the directory for theunixdomain socket.

as the directory for theUnix-domain socket.

</para>

</listitem>

</varlistentry>

<term>-D, --location <replaceable class="parameter">datadir</replaceable></term>

<listitem>

<para>

Specifies the alternativedatabaselocation. See also <xref

Specifies the alternative location for the database. See also <xref

linkend="app-initlocation">.

</para>

</listitem>

</varlistentry>

<varlistentry>

<term>-T, --template <replaceable class="parameter">template</replaceable></term>

<listitem>

<para>

Specifies the template database from which to build this database.

</para>

</listitem>

</varlistentry>

<varlistentry>

<term>-E, --encoding <replaceable class="parameter">encoding</replaceable></term>

<listitem>

<para>

Specifies the character encoding scheme to be usedwith this database.

Specifies the character encoding scheme to be usedin this database.

</para>

</listitem>

</varlistentry>

The options <literal>-h</literal>, <literal>-p</literal>, <literal>-U</literal>,

<literal>-W</literal>, and <literal>-e</literal> are passed on literally to

<xref linkend="app-psql">.

The options <literal>-D</literal>, <literal>-T</literal>, and

<literal>-E</literal> are converted into options for the underlying

SQL command <xref linkend="SQL-CREATEDATABASE"

endterm="SQL-CREATEDATABASE-title">, which see for more information

about them.

</para>

</refsect2>

<listitem>

<para>

The comment/description for the database could not be created.

the database itself will have been created already. You can use the

The database itself will have been created already. You can use the

<acronym>SQL</acronym> command <command>COMMENT ON DATABASE</command> to

create the comment later on.

</para>

the <productname>Postgres</productname> interactive terminal

<xref linkend="APP-PSQL">. Thus, there is nothing

special about creating databases via this or other methods. This means

that the <application>psql</application> must be found by the script and that

a database serverisrunning at the targetedhost. Also, any default

that the <application>psql</application>programmust be found by the script and that

a database servermust berunning at the targetedport. Also, any default

settings and environment variables available to <application>psql</application>

and the <application>libpq</application> front-end librarydo apply.

and the <application>libpq</application> front-end librarywill apply.

</para>

</refsect1>

CMDNAME=`basename$0`

PATHNAME=`echo$0| sed"s,$CMDNAME\$,,"`

MB=

TEMPLATE=

PSQLOPT=

dbname=

dbcomment=

--location=*)

dbpath=`echo"$1"| sed's/^--location=//'`

;;

--template|-T)

TEMPLATE="$2"

shift;;

-T*)

TEMPLATE=`echo"$1"| sed's/^-T//'`

;;

--template=*)

TEMPLATE=`echo"$1"| sed's/^--template=//'`

;;

--encoding|-E)

MB="$2"

shift;;

dbpath=`echo"$dbpath"| sed"s/'/\\\\\'/g"`

dbname=`echo"$dbname"| sed's/\"/\\\"/g'`

TEMPLATE=`echo"$TEMPLATE"| sed's/\"/\"\"/g'`

withstring=

["$dbpath" ]&& withstring="$withstring LOCATION = '$dbpath'"

["$MB" ]&& withstring="$withstring ENCODING = '$MB'"

["$TEMPLATE" ]&& withstring="$withstring TEMPLATE =\"$TEMPLATE\""

["$withstring" ]&& withstring=" WITH$withstring"

${PATHNAME}psql$PSQLOPT -d template1 -c"CREATE DATABASE\"$dbname\"$withstring"

me=`basename$0`

message"creating database\"$dbname\""

if [$?-ne 0 ];then

(exit 2);exit