<!--

$Header: /cvsroot/pgsql/doc/src/sgml/ref/createdb.sgml,v 1.27 2002/07/28 15:22:20 petere Exp $

$Header: /cvsroot/pgsql/doc/src/sgml/ref/createdb.sgml,v 1.28 2002/08/10 16:57:31 petere Exp $

PostgreSQL documentation

-->

<title>Environment</title>

<variablelist>

<varlistentry>

<term><envar>PGDATABASE</envar></term>

<listitem>

<para>

If set, the name of the database to create, unless overridden on

the command line.

</para>

</listitem>

</varlistentry>

<varlistentry>

<term><envar>PGHOST</envar></term>

<term><envar>PGPORT</envar></term>

<para>

Default connection parameters. <envar>PGUSER</envar> also

determines the name of the database to create, if it is not

specifiedin the command line.

specifiedon the command line or by <envar>PGDATABASE</envar>.

</para>

</listitem>

</varlistentry>

<refsect1 id="R1-APP-CREATEDB-2">

<title>Examples</title>

<informalexample>

<para>

To create the database <literal>demo</literal> using the default

database server:

The response is the same as you would have gotten from running the

<command>CREATE DATABASE</command> <acronym>SQL</acronym> command.

</para>

</informalexample>

<informalexample>

<para>

To create the database <literal>demo</literal> using the

server on host <literal>eden</>, port 5000, using the

<computeroutput>CREATE DATABASE</computeroutput>

</screen>

</para>

</informalexample>

</refsect1>

<!--

$Header: /cvsroot/pgsql/doc/src/sgml/ref/createlang.sgml,v 1.25 2002/07/28 15:22:20 petere Exp $

$Header: /cvsroot/pgsql/doc/src/sgml/ref/createlang.sgml,v 1.26 2002/08/10 16:57:31 petere Exp $

PostgreSQL documentation

-->

<variablelist>

<varlistentry>

<term><envar>PGDATABASE</envar></term>

<term><envar>PGHOST</envar></term>

<term><envar>PGPORT</envar></term>

<term><envar>PGUSER</envar></term>

<refsect1>

<title>Examples</title>

<informalexample>

<para>

To install <literal>pltcl</literal> into the database

<literal>template1</literal>:

<screen>

<prompt>$ </prompt><userinput>createlang pltcl template1</userinput>

</screen>

</para>

</informalexample>

</refsect1>

<refsect1>

<!--

$Header: /cvsroot/pgsql/doc/src/sgml/ref/createuser.sgml,v 1.26 2002/07/28 15:22:20 petere Exp $

$Header: /cvsroot/pgsql/doc/src/sgml/ref/createuser.sgml,v 1.27 2002/08/10 16:57:31 petere Exp $

PostgreSQL documentation

-->

<listitem>

<para>

The new user is allowed to create other users.

(Note:actually, this makes the new user a <firstterm>superuser</>.

(Note:Actually, this makes the new user a <firstterm>superuser</>.

The option is poorly named.)

</para>

</listitem>

<refsect1>

<title>Examples</title>

<informalexample>

<para>

To create a user <literal>joe</literal> on the default database

server:

<computeroutput>CREATE USER</computeroutput>

</screen>

</para>

</informalexample>

<informalexample>

<para>

To create the same user <literal>joe</literal> using the

server on host <literal>eden</>, port 5000, avoiding the prompts and

<computeroutput>CREATE USER</computeroutput>

</screen>

</para>

</informalexample>

</refsect1>

<!--

$Header: /cvsroot/pgsql/doc/src/sgml/ref/dropdb.sgml,v 1.16 2002/07/28 15:22:20 petere Exp $

$Header: /cvsroot/pgsql/doc/src/sgml/ref/dropdb.sgml,v 1.17 2002/08/10 16:57:31 petere Exp $

PostgreSQL documentation

-->

<refsect1 id="R1-APP-DROPDB-2">

<title>Examples</title>

<informalexample>

<para>

To destroy the database <literal>demo</literal> on the default

database server:

<computeroutput>DROP DATABASE</computeroutput>

</screen>

</para>

</informalexample>

<informalexample>

<para>

To destroy the database <literal>demo</literal> using the

server on host <literal>eden</literal>, port 5000, with verification and a peek

DROP DATABASE</computeroutput>

</screen>

</para>

</informalexample>

</refsect1>

<!--

$Header: /cvsroot/pgsql/doc/src/sgml/ref/droplang.sgml,v 1.19 2002/07/28 15:22:20 petere Exp $

$Header: /cvsroot/pgsql/doc/src/sgml/ref/droplang.sgml,v 1.20 2002/08/10 16:57:31 petere Exp $

PostgreSQL documentation

-->

<variablelist>

<varlistentry>

<term><envar>PGDATABASE</envar></term>

<term><envar>PGHOST</envar></term>

<term><envar>PGPORT</envar></term>

<term><envar>PGUSER</envar></term>

<refsect1>

<title>Examples</title>

<informalexample>

<para>

To remove <literal>pltcl</literal>:

<screen>

<prompt>$ </prompt><userinput>droplang pltcl dbname</userinput>

</screen>

</para>

</informalexample>

</refsect1>

<refsect1>

<!--

$Header: /cvsroot/pgsql/doc/src/sgml/ref/dropuser.sgml,v 1.19 2002/07/28 15:22:20 petere Exp $

$Header: /cvsroot/pgsql/doc/src/sgml/ref/dropuser.sgml,v 1.20 2002/08/10 16:57:31 petere Exp $

PostgreSQL documentation

-->

<refsect1>

<title>Examples</title>

<informalexample>

<para>

To remove user <literal>joe</literal> from the default database

server:

<computeroutput>DROP USER</computeroutput>

</screen>

</para>

</informalexample>

<informalexample>

<para>

To remove user <literal>joe</literal> using the postmaster on host

<literal>eden</literal>, port 5000, with verification and a peek at the underlying

DROP USER</computeroutput>

</screen>

</para>

</informalexample>

</refsect1>

<!--

$Header: /cvsroot/pgsql/doc/src/sgml/ref/pg_dump.sgml,v 1.46 2002/07/28 15:22:20 petere Exp $

$Header: /cvsroot/pgsql/doc/src/sgml/ref/pg_dump.sgml,v 1.47 2002/08/10 16:57:31 petere Exp $

PostgreSQL documentation

-->

<arg>-p <replaceable>port</replaceable></arg>

<arg>-U <replaceable>username</replaceable></arg>

<arg>-W</arg>

<arg choice="plain"><replaceable>dbname</replaceable></arg>

<arg><replaceable>dbname</replaceable></arg>

</cmdsynopsis>

</refsynopsisdiv>

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

<listitem>

<para>

Specifies the name of the database to be dumped.

Specifies the name of the database to be dumped. If this is

not specified, the environment variable

<envar>PGDATABASE</envar> is used. If that is not set, the

user name specified for the connection is used.

</para>

</listitem>

</varlistentry>

<term><option>-U <replaceable>username</replaceable></option></term>

<listitem>

<para>

Connect as the given user.

Connect as the given user

</para>

</listitem>

</varlistentry>

<variablelist>

<varlistentry>

<term><envar>PGDATABASE</envar></term>

<listitem>

<para>

Database to dump, unless overridden on the command line.

</para>

</listitem>

</varlistentry>

<varlistentry>

<term><envar>PGHOST</envar></term>

<term><envar>PGPORT</envar></term>

<term><envar>PGUSER</envar></term>

<!-- $Header: /cvsroot/pgsql/doc/src/sgml/ref/pg_restore.sgml,v 1.29 2002/07/28 15:22:20 petere Exp $ -->

<!-- $Header: /cvsroot/pgsql/doc/src/sgml/ref/pg_restore.sgml,v 1.30 2002/08/10 16:57:31 petere Exp $ -->

<refentry id="APP-PGRESTORE">

<docinfo>

<term><option>-U <replaceable>username</replaceable></option></term>

<listitem>

<para>

Connect as the given user.

Connect as the given user

</para>

</listitem>

</varlistentry>

<!--

$Header: /cvsroot/pgsql/doc/src/sgml/ref/vacuumdb.sgml,v 1.22 2002/07/28 15:22:21 petere Exp $

$Header: /cvsroot/pgsql/doc/src/sgml/ref/vacuumdb.sgml,v 1.23 2002/08/10 16:57:31 petere Exp $

PostgreSQL documentation

-->

<listitem>

<para>

Specifies the name of the database to be cleaned or analyzed.

If this is not specified and <option>-a</option> (or

<option>--all</option>) is not used, the database name is read

from the environment variable <envar>PGDATABASE</envar>. If

that is not set, the user name specified for the connection is

used.

</para>

</listitem>

</varlistentry>

<variablelist>

<varlistentry>

<term><envar>PGDATABASE</envar></term>

<term><envar>PGHOST</envar></term>

<term><envar>PGPORT</envar></term>

<term><envar>PGUSER</envar></term>

<refsect1>

<title>Examples</title>

<informalexample>

<para>

To clean the database <literal>test</literal>:

<screen>

<prompt>$ </prompt><userinput>vacuumdb test</userinput>

</screen>

</para>

</informalexample>

<informalexample>

<para>

To clean and analyze for the optimizer a database named

<literal>bigdb</literal>:

<screen>

<prompt>$ </prompt><userinput>vacuumdb --analyze bigdb</userinput>

</screen>

</para>

</informalexample>

<informalexample>

<para>

To clean a single table

<literal>foo</literal> in a database named

<prompt>$ </prompt><userinput>vacuumdb --analyze --verbose --table 'foo(bar)' xyzzy</userinput>

</screen>

</para>

</informalexample>

</refsect1>