Error in using copy command

From: Sindile Bidla <sindile(dot)bidla(at)gmail(dot)com>
To: pgsql-novice <pgsql-novice(at)postgresql(dot)org>
Subject: Error in using copy command
Date: 2011-05-11 12:09:17
Message-ID: BANLkTimc9cvze-RrJfnCiEni5+PPFJUdQQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

I get the following error on running COPY - array value must start with "{"
or dimension information CONTEXT: copy tablename, line 1, column field1:
""1"".

the structure of the csv file is: "1","1","BLOEMSMOND SETTLEMENT
AGRICULTURAL HOLDING","00000","","","T618/1943","6.3870 H","NORTHERN
CAPE","","*"

my copy command looks is: COPY tablename FROM myfile DELIMITER ',';

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Michael Wood 2011-05-11 12:28:16 Re: Error in using copy command
Previous Message JORGE MALDONADO 2011-05-10 22:30:43 Recommendation for writing a select statement.