COPY command

From: azwa(at)nc(dot)com(dot)my
To: pgsql-sql(at)postgresql(dot)org
Subject: COPY command
Date: 2004-01-07 06:19:53
Message-ID: OF712FFBCF.3764ED48-ONFFFFFF42.003DBFA8@nc.com.my
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Browse pgsql-sql by date

  From Date Subject
Next Message Chris Travers 2004-01-07 07:49:28 Re: Calendar Scripts - Quite a complex one
Previous Message Kumar 2004-01-07 06:06:16 Re: Calendar Scripts - Quite a complex one