From: azwa@nc.com.my
To: pgsql-sql@postgresql.org
Subject: data loading
Date: Fri, 9 Jan 2004 10:13:09 +0800
Message-ID: <OF9676234F.055C727D-ONFFFFFF44.00279362@nc.com.my> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: azwa@nc.com.my
Subject: Re: data loading
In-Reply-To: <OF9676234F.055C727D-ONFFFFFF44.00279362@nc.com.my>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox