From: | azwa(at)nc(dot)com(dot)my |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | COPY command |
Date: | 2004-01-07 08:35:13 |
Message-ID: | OF845B979C.D4EAB518-ON48256E14.002F23E4@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
From | Date | Subject | |
---|---|---|---|
Next Message | Brendan LeFebvre | 2004-01-07 11:14:40 | Different query results in psql and Perl DBI with Postgres 7.2.1 |
Previous Message | Chris Travers | 2004-01-07 07:49:28 | Re: Calendar Scripts - Quite a complex one |