[SQL] data loading

[azwa]

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


do u have any idea what causes the above error ???or is there any command can be used to load data as requested. tq