From 16a18786623d00e174aee8ee67b059c637973cd2 Mon Sep 17 00:00:00 2001
From: Andrew Dunstan <andrew@dunslane.net>
Date: Mon, 5 Sep 2005 14:44:05 +0000
Subject: [PATCH] Add a note about CSV lines with trailing spaces. Suggestion
 by Darcy Buskermolen, reworded by me.

---
 doc/src/sgml/ref/copy.sgml | 13 +++++++++++++
 1 file changed, 13 insertions(+)

diff --git a/doc/src/sgml/ref/copy.sgml b/doc/src/sgml/ref/copy.sgml
index 8cc2ab98f3..8478fb90e4 100644
--- a/doc/src/sgml/ref/copy.sgml
+++ b/doc/src/sgml/ref/copy.sgml
@@ -511,6 +511,19 @@ COPY <replaceable class="parameter">tablename</replaceable> [ ( <replaceable cla
     comparisons for specific columns.
    </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
-- 
2.39.5