COPY command
От | azwa@nc.com.my |
---|---|
Тема | COPY command |
Дата | |
Msg-id | OF712FFBCF.3764ED48-ONFFFFFF42.003DBFA8@nc.com.my обсуждение исходный текст |
Список | pgsql-sql |
<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>
В списке pgsql-sql по дате отправления: