X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (neptune.hub.org [200.46.204.2])
	by svr1.postgresql.org (Postfix) with ESMTP id 89B85D1B447
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri,  9 Jan 2004 02:45:25 +0000 (GMT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024)
	with ESMTP id 18301-04
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Thu,  8 Jan 2004 22:44:40 -0400 (AST)
Received: from domino.nc.com.my (domino.nc.com.my [202.185.214.131])
	by svr1.postgresql.org (Postfix) with ESMTP id 975E4D1B448
	for <pgsql-sql@postgresql.org>; Thu,  8 Jan 2004 22:35:08 -0400 (AST)
Subject: data loading 
To: pgsql-sql@postgresql.org
X-Mailer: Lotus Notes Release 5.0 (Intl) 30 March 1999
Message-ID: <OF9676234F.055C727D-ONFFFFFF44.00279362@nc.com.my>
From: azwa@nc.com.my
Date: Fri, 9 Jan 2004 10:13:09 +0800
X-MIMETrack: Serialize by Router on domino/ANSI(Release 5.0.5 |September 22,
	2000) at 01/09/2004 10:14:02 AM,
	Serialize complete at 01/09/2004 10:14:02 AM
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="=_alternative 000E4FEC48256E16_="
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Spam-Status: No, hits=1.7 tagged_above=0.0 required=5.0 tests=HTML_30_40,
	NO_REAL_NAME
X-Spam-Level: *
X-Archive-Number: 200401/59
X-Sequence-Number: 16452

This is a multipart message in MIME format.
--=_alternative 000E4FEC48256E16_=
Content-Type: text/plain; charset="us-ascii"

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 
--=_alternative 000E4FEC48256E16_=
Content-Type: text/html; charset="us-ascii"




<br><font size=2 face="Times New Roman">Hi,</font>
<br>
<br>
<br><font size=2 face="Times New Roman">&nbsp; i try to load data from flat file (comma delimiter format) into temporary table . i use COPY command as below:</font>
<br>
<br><font size=2 face="Times New Roman">dwnc=# copy biosadm.custdo_temp</font><font face="Times New Roman"> </font><font size=2 face="Times New Roman"><br>
dwnc-# from '/home/bios/customer_data/CustomerDO_new.CSV'</font><font face="Times New Roman"> </font><font size=2 face="Times New Roman"><br>
dwnc-# WITH DELIMITER ',' ;</font><font face="Times New Roman"> <br>
</font><font size=2 face="Times New Roman"><br>
ERROR: &nbsp;copy: line 141, Extra data after last expected column</font><font face="Times New Roman"> </font>
<br>
<br>
<br><font size=2 face="Times New Roman">do u have any idea what causes the above error ???or is there any command can be used to load data as requested. tq </font>
--=_alternative 000E4FEC48256E16_=--