diff options
| author | Andrew Dunstan <andrew@dunslane.net> | 2005-09-05 14:44:05 +0000 |
|---|---|---|
| committer | Andrew Dunstan <andrew@dunslane.net> | 2005-09-05 14:44:05 +0000 |
| commit | 2739e1d1c268635f3cbc7554736d0719993a6f46 (patch) | |
| tree | 2da209139ff0d986bcbb641111248cabf48798db /doc/src | |
| parent | 656fe39b84329a8b5cc5bef560e1d90137adf26e (diff) | |
| download | postgresql-2739e1d1c268635f3cbc7554736d0719993a6f46.tar.gz postgresql-2739e1d1c268635f3cbc7554736d0719993a6f46.zip | |
Add a note about CSV lines with trailing spaces.
Suggestion by Darcy Buskermolen, reworded by me.
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/ref/copy.sgml | 15 |
1 files changed, 14 insertions, 1 deletions
diff --git a/doc/src/sgml/ref/copy.sgml b/doc/src/sgml/ref/copy.sgml index 188f892fa0f..34f1b496ebf 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.66 2005/06/02 01:21:21 momjian Exp $ +$PostgreSQL: pgsql/doc/src/sgml/ref/copy.sgml,v 1.67 2005/09/05 14:44:05 adunstan Exp $ PostgreSQL documentation --> @@ -512,6 +512,19 @@ COPY <replaceable class="parameter">tablename</replaceable> [ ( <replaceable cla </para> <note> + <para> + In <literal>CSV</> mode, all characters are significant. A quoted value + surrounded by white space, or any characters other than + <literal>DELIMITER</>, will include those characters. This can cause + errors if you import data from a system that pads <literal>CSV</> + lines with white space out to some fixed width. If such a situation + arises you might need to preprocess the <literal>CSV</> file to remove + the trailing white space, before importing the data into + <productname>PostgreSQL</>. + </para> + </note> + + <note> <para> CSV mode will both recognize and produce CSV files with quoted values containing embedded carriage returns and line feeds. Thus |