Do you have an extra delimiter at the end of the record?
-----Original Message-----
From: muratmy@hotmail.com [mailto:muratmy@hotmail.com]
Sent: Thursday, February 21, 2002 5:55 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] copy notice
Hi ,
I load a | delimited text file into a table using the following command :
copy table_name from '/usr/local/pgsql/table_name.dat' using delimiters '|';
and get this notice for each row :
NOTICE: copy: line 21579, CopyReadNewline: extra fields ignored
but the rows are loaded succesfully, why do I get this notice ?
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)