data loading - Mailing list pgsql-sql

From azwa@nc.com.my
Subject data loading
Date
Msg-id OF9676234F.055C727D-ONFFFFFF44.00279362@nc.com.my
Whole thread Raw
Responses Re: data loading
Re: data loading
List 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 by date:

Previous
From: Evan Klinger
Date:
Subject: PostgreSQL Array Syntax
Next
From: Lance Munslow
Date:
Subject: Date select question...