diff options
| author | Bruce Momjian | 2005-05-07 02:22:49 +0000 |
|---|---|---|
| committer | Bruce Momjian | 2005-05-07 02:22:49 +0000 |
| commit | b63990c6a8387c8cae9c253508c333e267f9d442 (patch) | |
| tree | 08fd4a0f738b365f31bb1a0d627f9cfd343f2c9a /doc/src | |
| parent | ce1ab398ddbd7fad9f2764176098467110f803ee (diff) | |
Add COPY WITH CVS HEADER to allow a heading line as the first line in
COPY.
Andrew Dunstan
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/ref/copy.sgml | 22 |
1 files changed, 18 insertions, 4 deletions
diff --git a/doc/src/sgml/ref/copy.sgml b/doc/src/sgml/ref/copy.sgml index e907da0b5d0..0dd10d6754d 100644 --- a/doc/src/sgml/ref/copy.sgml +++ b/doc/src/sgml/ref/copy.sgml @@ -1,5 +1,5 @@ <!-- -$PostgreSQL: pgsql/doc/src/sgml/ref/copy.sgml,v 1.64 2005/05/06 03:38:05 momjian Exp $ +$PostgreSQL: pgsql/doc/src/sgml/ref/copy.sgml,v 1.65 2005/05/07 02:22:45 momjian Exp $ PostgreSQL documentation --> @@ -24,11 +24,12 @@ PostgreSQL documentation COPY <replaceable class="parameter">tablename</replaceable> [ ( <replaceable class="parameter">column</replaceable> [, ...] ) ] FROM { '<replaceable class="parameter">filename</replaceable>' | STDIN } [ [ WITH ] - [ BINARY ] + [ BINARY ] [ OIDS ] [ DELIMITER [ AS ] '<replaceable class="parameter">delimiter</replaceable>' ] [ NULL [ AS ] '<replaceable class="parameter">null string</replaceable>' ] - [ CSV [ QUOTE [ AS ] '<replaceable class="parameter">quote</replaceable>' ] + [ CSV [ HEADER ] + [ QUOTE [ AS ] '<replaceable class="parameter">quote</replaceable>' ] [ ESCAPE [ AS ] '<replaceable class="parameter">escape</replaceable>' ] [ FORCE NOT NULL <replaceable class="parameter">column</replaceable> [, ...] ] @@ -36,10 +37,12 @@ COPY <replaceable class="parameter">tablename</replaceable> [ ( <replaceable cla TO { '<replaceable class="parameter">filename</replaceable>' | STDOUT } [ [ WITH ] [ BINARY ] + [ HEADER ] [ OIDS ] [ DELIMITER [ AS ] '<replaceable class="parameter">delimiter</replaceable>' ] [ NULL [ AS ] '<replaceable class="parameter">null string</replaceable>' ] - [ CSV [ QUOTE [ AS ] '<replaceable class="parameter">quote</replaceable>' ] + [ CSV [ HEADER ] + [ QUOTE [ AS ] '<replaceable class="parameter">quote</replaceable>' ] [ ESCAPE [ AS ] '<replaceable class="parameter">escape</replaceable>' ] [ FORCE QUOTE <replaceable class="parameter">column</replaceable> [, ...] ] </synopsis> @@ -192,6 +195,17 @@ COPY <replaceable class="parameter">tablename</replaceable> [ ( <replaceable cla </varlistentry> <varlistentry> + <term><literal>HEADER</literal></term> + <listitem> + <para> + Specifies the file contains a header line with the names of each + column in the file. On output, the first line contains the column + names from the table, and on input, the first line is ignored. + </para> + </listitem> + </varlistentry> + + <varlistentry> <term><replaceable class="parameter">quote</replaceable></term> <listitem> <para> |