data loading

From: azwa(at)nc(dot)com(dot)my
To: pgsql-sql(at)postgresql(dot)org
Subject: data loading
Date: 2004-01-09 02:13:09
Message-ID: OF9676234F.055C727D-ONFFFFFF44.00279362@nc.com.my
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Gregory S. Williamson 2004-01-09 03:06:27 Re: COPY command
Previous Message Johannes Lochmann 2004-01-08 14:17:44 Re: Start-up problems