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 43A93D1B42F for ; Wed, 7 Jan 2004 06:42:05 +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 61006-05 for ; Wed, 7 Jan 2004 02:41:17 -0400 (AST) Received: from domino.nc.com.my (domino.nc.com.my [202.185.214.131]) by svr1.postgresql.org (Postfix) with ESMTP id 54F33D1B44A for ; Wed, 7 Jan 2004 02:41:15 -0400 (AST) Subject: COPY command To: pgsql-sql@postgresql.org X-Mailer: Lotus Notes Release 5.0 (Intl) 30 March 1999 Message-ID: From: azwa@nc.com.my Date: Wed, 7 Jan 2004 14:19:53 +0800 X-MIMETrack: Serialize by Router on domino/ANSI(Release 5.0.5 |September 22, 2000) at 01/07/2004 02:20:06 PM, Serialize complete at 01/07/2004 02:20:06 PM MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="=_alternative 0024E55748256E14_=" 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/51 X-Sequence-Number: 16444 This is a multipart message in MIME format. --=_alternative 0024E55748256E14_= Content-Type: text/plain; charset="us-ascii" Hi, i try to load a file into temporary table but it gives me an error . do u have any idea/solutions ?? the command that i've running 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 FYI, my file was in comma delimiter type (csv) . My table structure as following : dwnc-# \dbiosadm.custdo_temp Table "biosadm.custdo_temp" Column | Type | Modifiers ----------+-----------------------+----------- dono | character varying(13) | dodate | date | custname | character varying(70) | custlo | character varying(40) | attnto | character varying(80) | Please guide me . thanks --=_alternative 0024E55748256E14_= Content-Type: text/html; charset="us-ascii"
Hi,


  i try to load a file into temporary table but it gives me an error . do u have any idea/solutions ??  the command that i've running 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

FYI, my file was in comma delimiter type (csv) . My table structure as following :

    dwnc-# \dbiosadm.custdo_temp
         Table "biosadm.custdo_temp"
  Column  |         Type          | Modifiers
----------+-----------------------+-----------
 dono     | character varying(13) |
 dodate   | date                  |
 custname | character varying(70) |
 custlo   | character varying(40) |
 attnto   | character varying(80) |


Please guide me . thanks --=_alternative 0024E55748256E14_=--