<br /><font face="Times New Roman" size="2">Hi,</font><br /><br /><br /><font face="Times New Roman" size="2"> i try
toload a file into temporary table but it gives me an error . do u have any idea/solutions ?? the command that i've
runningas below :</font><br /><br /><br /><font face="Times New Roman" size="2"> dwnc=# copy
biosadm.custdo_temp</font><br/><font face="Times New Roman" size="2">dwnc-# from
'/home/bios/customer_data/CustomerDO_new.CSV'</font><br/><font face="Times New Roman" size="2">dwnc-# WITH DELIMITER
',';</font><br /><br /><font face="Times New Roman" size="2">ERROR: copy: line 141, Extra data after last expected
column</font><br/><br /><font face="Times New Roman" size="2">FYI, my file was in comma delimiter type (csv) . My table
structureas following :</font><br /><br /><font face="Times New Roman" size="2"> dwnc-#
\dbiosadm.custdo_temp</font><br/><font face="Times New Roman" size="2"> Table "biosadm.custdo_temp"</font><br
/><fontface="Times New Roman" size="2"> Column | Type | Modifiers</font><br /><font face="Times New
Roman"size="2">----------+-----------------------+-----------</font><br /><font face="Times New Roman" size="2"> dono
| character varying(13) |</font><br /><font face="Times New Roman" size="2"> dodate | date
|</font><br/><font face="Times New Roman" size="2"> custname | character varying(70) |</font><br /><font face="Times
NewRoman" size="2"> custlo | character varying(40) |</font><br /><font face="Times New Roman" size="2"> attnto |
charactervarying(80) |</font><br /><br /><br /><font face="Times New Roman" size="2">Please guide me . thanks</font>
