Re: data loading

On Friday 09 January 2004 02:13, azwa@nc.com.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