Personal experience says one of your fields in that line has a control
character or quite possibly a | itself. causing copy to read that field
as more than one field. Check those lines for odd characters.
The rows will load succesfully, but will truncate whatever it thinks is
'extra'. You should to edit those specific lines and get rid of
whatever's cuasing that error in order to claim everything is imported the
way your pipe delimitted file suggests it should be.
.jtp
> 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)
>