data loading
| От | azwa@nc.com.my |
|---|---|
| Тема | data loading |
| Дата | |
| Msg-id | OF9676234F.055C727D-ONFFFFFF44.00279362@nc.com.my обсуждение исходный текст |
| Ответы |
Re: data loading
Re: data loading |
| Список | 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 data from flat file (comma delimiter format) into temporary table . i use COPY command as below:</font><br /><br /><fontface="Times New Roman" size="2">dwnc=# copy biosadm.custdo_temp</font><font face="Times New Roman"> </font><font face="TimesNew Roman" size="2"><br /> dwnc-# from '/home/bios/customer_data/CustomerDO_new.CSV'</font><font face="Times NewRoman"> </font><font face="Times New Roman" size="2"><br /> dwnc-# WITH DELIMITER ',' ;</font><font face="Times New Roman"><br/></font><font face="Times New Roman" size="2"><br /> ERROR: copy: line 141, Extra data after last expected column</font><fontface="Times New Roman"> </font><br /><br /><br /><font face="Times New Roman" size="2">do u have any ideawhat causes the above error ???or is there any command can be used to load data as requested. tq </font>
В списке pgsql-sql по дате отправления: