<!--

$Header: /cvsroot/pgsql/doc/src/sgml/ref/copy.sgml,v 1.35 2002/08/02 18:15:04 tgl Exp $

$Header: /cvsroot/pgsql/doc/src/sgml/ref/copy.sgml,v 1.36 2002/08/04 05:09:36 momjian Exp $

PostgreSQL documentation

-->

</varlistentry>

<varlistentry>

<term><replaceable class="parameter">column list</replaceable></term>

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

<listitem>

<para>

An optional list of columns to be copied. If no column list is

<para>

Changes the behavior of field formatting, forcing all data to be

stored or read in binary format rather than as text. You can not

specify DELIMITER or NULL in binary mode.

specify <option>DELIMITER</option>, <option>NULL</option>, or

a column list in binary mode.

</para>

</listitem>

</varlistentry>

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

<listitem>

<para>

The character that separates fields within each row (line) of the file.

Thesinglecharacter that separates fields within each row (line) of the file.

</para>

</listitem>

</varlistentry>

<para>

<command>COPY</command> moves data between

<productname>PostgreSQL</productname> tables and standard file-system

files.

<command>COPY TO</command> copies the entire contents of a table

files. <command>COPY TO</command> copies the contents of a table

<emphasis>to</> a file, while <command>COPY FROM</command> copies

data <emphasis>from</> a file to a table (appending the data to

whatever is in the table already).

<para>

If a list of columns is specified, <command>COPY</command> will

only copy the data in the specified columns to or from the file.

If there are any columns in the table that are not in thefile,

If there are any columns in the table that are not in thecolumn list,

<command>COPY FROM</command> will insert the default values for

those columns.

</para>

<para>

By default, a text copy uses a tab ("\t") character as a delimiter

between fields. The field delimiter may be changed to any other

single character with the keyword DELIMITER. Characters in data

fields that happen to match the delimiter character will be

single character with the keyword<option>DELIMITER</option>. Characters

in data fields that happen to match the delimiter character will be

backslash quoted.

</para>

Usage

</title>

<para>

The following example copies a table to standard output,

using a vertical bar (|) as the field

delimiter:

The following example copies a table to standard output,

using a vertical bar (|) as the field delimiter:

</para>

<programlisting>

COPY country TO <filename>stdout</filename> WITH DELIMITER '|';

</programlisting>

<para>

To copy data from a Unix file intoa tablecountry:

To copy data from a Unix file intothe <literal>country</> table:

</para>

<programlisting>

COPY country FROM '/usr1/proj/bray/sql/country_data';

<!--

$Header: /cvsroot/pgsql/doc/src/sgml/ref/set.sgml,v 1.63 2002/08/0403:53:11 momjian Exp $

$Header: /cvsroot/pgsql/doc/src/sgml/ref/set.sgml,v 1.64 2002/08/0405:09:36 momjian Exp $

PostgreSQL documentation

-->

</varlistentry>

<varlistentry>

<term><computeroutput>ERROR: not a valid option name: <replaceable>name</replaceable></computeroutput></term>

<term><computeroutput>ERROR: '<replaceable>name</replaceable> is not a

valid option name</computeroutput></term>

<listitem>

<para>

The parameter you tried to set does not exist.

</varlistentry>

<varlistentry>

<term><computeroutput>ERROR: permission denied</computeroutput></term>

<term><computeroutput>ERROR: '<replaceable>name</replaceable>':

permission denied</computeroutput></term>

<listitem>

<para>

You must be a superuser to alter certain settings.

</varlistentry>

<varlistentry>

<term><computeroutput>ERROR: <replaceable>name</replaceable> can only be set at start-up</computeroutput></term>

<term><computeroutput>ERROR: '<replaceable>name</replaceable>' cannot

be changed after server start</computeroutput></term>

<listitem>

<para>

Some parameters are fixed once the server is started.

<!--

$Header: /cvsroot/pgsql/doc/src/sgml/ref/show.sgml,v 1.18 2002/08/0403:53:11 momjian Exp $

$Header: /cvsroot/pgsql/doc/src/sgml/ref/show.sgml,v 1.19 2002/08/0405:09:36 momjian Exp $

PostgreSQL documentation

-->

<para>

<command>SHOW</command> will display the current setting of a

run-time parameter. These variables can be set using the

<command>SET</command> statement or are determined at session start.

<command>SET</command> statement, by editing the

<filename>postgresql.conf</filename>, through the

<envar>PGOPTIONS</envar> environmental variable, or through a

command-line flag when starting the

<application>postmaster</application>.

</para>

</refsect1>

<para>

<variablelist>

<varlistentry>

<term><computeroutput>ERROR: not a valid option name: <replaceable>name</replaceable></computeroutput></term>

<term><computeroutput>ERROR: Option '<replaceable>name</replaceable>'

is not recognized</computeroutput></term>

<listitem>

<para>

Message returned if <replaceable>variable</replaceable> does

Message returned if <replaceable>name</replaceable> does

not stand for an existing parameter.

</para>

</listitem>

<para>

Show the current <literal>DateStyle</literal> setting:

<screen>

<programlisting>

SHOW DateStyle;

DateStyle

---------------------------------------

ISO with US (NonEuropean) conventions

(1 row)

</screen>

</programlisting>

</para>

<para>

Show the current genetic optimizer (<literal>geqo</literal>) setting:

<programlisting>

<screen>

SHOW GEQO;

geqo

------

on

(1 row)

</screen>

</programlisting>

</para>

<para>

if (pgStatSock<0)

return;

MemSet(&(msg.m_hdr),0,sizeof(msg.m_hdr));

msg.m_hdr.m_type=PGSTAT_MTYPE_BETERM;

msg.m_hdr.m_backendid=0;

msg.m_hdr.m_procpid=pid;

msg.m_hdr.m_databaseid=0;

pgstat_send(&msg,sizeof(msg));

}