<!--

$PostgreSQL: pgsql/doc/src/sgml/ref/createdb.sgml,v 1.39 2004/06/18 21:24:02 tgl Exp $

$PostgreSQL: pgsql/doc/src/sgml/ref/createdb.sgml,v 1.40 2004/06/18 21:47:23 tgl Exp $

PostgreSQL documentation

-->

<term><replaceable class="parameter">dbname</replaceable></term>

<listitem>

<para>

Specifies the name of the database to be created. The name must be

unique among all <productname>PostgreSQL</productname> databases in this cluster.

Specifies the name of the database to be created. The name must be

unique among all <productname>PostgreSQL</productname> databases in this cluster.

The default is to create a database with the same name as the

current system user.

</para>

<term><replaceable class="parameter">description</replaceable></term>

<listitem>

<para>

This optionally specifies a comment to be associated with the newly created

database.

Specifies a comment to be associated with the newly created

database.

</para>

</listitem>

</varlistentry>

<varlistentry>

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

<term><option>--location <replaceable class="parameter">location</replaceable></></term>

<term><option>-D <replaceable class="parameter">tablespace</replaceable></></term>

<term><option>--tablespace <replaceable class="parameter">tablespace</replaceable></></term>

<listitem>

<para>

Specifies thealternative location for the database.

Specifies thedefault tablespace for the database.

</para>

</listitem>

</varlistentry>

<listitem>

<para>

Echo the commands that <application>createdb</application> generates

and sends to the server.

and sends to the server.

</para>

</listitem>

</varlistentry>

<term><option>--owner <replaceable class="parameter">owner</replaceable></></term>

<listitem>

<para>

Specifies the database user who will own the new database.

Specifies the database user who will own the new database.

</para>

</listitem>

</varlistentry>

<term><option>--host <replaceable class="parameter">host</replaceable></></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.

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>

<term><option>--port <replaceable class="parameter">port</replaceable></></term>

<listitem>

<para>

Specifies the TCP port or the local Unix domain socket file

extension on which the server is listening for connections.

Specifies the TCP port or the local Unix domain socket file

extension on which the server is listening for connections.

</para>

</listitem>

</varlistentry>

{"echo",no_argument,NULL,'e'},

{"quiet",no_argument,NULL,'q'},

{"owner",required_argument,NULL,'O'},

{"location",required_argument,NULL,'D'},

{"tablespace",required_argument,NULL,'D'},

{"template",required_argument,NULL,'T'},

{"encoding",required_argument,NULL,'E'},

{NULL,0,NULL,0}

boolecho= false;

boolquiet= false;

char*owner=NULL;

char*location=NULL;

char*tablespace=NULL;

char*template=NULL;

char*encoding=NULL;

owner=optarg;

break;

case'D':

location=optarg;

tablespace=optarg;

break;

case'T':

template=optarg;

if (owner)

appendPQExpBuffer(&sql," OWNER %s",fmtId(owner));

if (location)

{

appendPQExpBuffer(&sql," LOCATION ");

appendStringLiteral(&sql,location, false);

}

if (tablespace)

appendPQExpBuffer(&sql," TABLESPACE %s",fmtId(tablespace));

if (encoding)

appendPQExpBuffer(&sql," ENCODING '%s'",encoding);

if (template)

printf(_("Usage:\n"));

printf(_(" %s [OPTION]... [DBNAME] [DESCRIPTION]\n"),progname);

printf(_("\nOptions:\n"));

printf(_(" -D, --location=PATH alternative place to store the database\n"));

printf(_(" -E, --encoding=ENCODING encoding for the database\n"));

printf(_(" -O, --owner=OWNER database user to own the new database\n"));

printf(_(" -T, --template=TEMPLATE template database to copy\n"));

printf(_(" -e, --echo show the commands being sent to the server\n"));

printf(_(" -q, --quiet don't write any messages\n"));

printf(_(" --help show this help, then exit\n"));

printf(_(" --version output version information, then exit\n"));

printf(_(" -D, --tablespace=TABLESPACE default tablespace for the database\n"));

printf(_(" -E, --encoding=ENCODINGencoding for the database\n"));

printf(_(" -O, --owner=OWNERdatabase user to own the new database\n"));

printf(_(" -T, --template=TEMPLATEtemplate database to copy\n"));

printf(_(" -e, --echoshow the commands being sent to the server\n"));

printf(_(" -q, --quietdon't write any messages\n"));

printf(_(" --helpshow this help, then exit\n"));

printf(_(" --versionoutput version information, then exit\n"));

printf(_("\nConnection options:\n"));

printf(_(" -h, --host=HOSTNAME database server host or socket directory\n"));

printf(_(" -p, --port=PORT database server port\n"));

printf(_(" -U, --username=USERNAME user name to connect as\n"));

printf(_(" -W, --password prompt for password\n"));

printf(_(" -h, --host=HOSTNAMEdatabase server host or socket directory\n"));

printf(_(" -p, --port=PORTdatabase server port\n"));

printf(_(" -U, --username=USERNAMEuser name to connect as\n"));

printf(_(" -W, --passwordprompt for password\n"));

printf(_("\nBy default, a database with the same name as the current user is created.\n"));

printf(_("\nReport bugs to <pgsql-bugs@postgresql.org>.\n"));

}