Re: copy notice

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)