On Friday 09 January 2004 02:13, azwa(at)nc(dot)com(dot)my wrote:
> Hi,
>
>
> i try to load data from flat file (comma delimiter format) into
> temporary table . i use COPY command as below:
>
> dwnc=# copy biosadm.custdo_temp
> dwnc-# from '/home/bios/customer_data/CustomerDO_new.CSV'
> dwnc-# WITH DELIMITER ',' ;
>
> ERROR: copy: line 141, Extra data after last expected column
Does line 141 (or nearby) have a comma somewhere in its data? That would fool
the COPY into mis-counting the columns. See the COPY entry in the SQL Command
Reference chapter of the manuals - you'll want to escape any commas with a
backslash:
\,
--
Richard Huxton
Archonet Ltd