Skip site navigation (1) Skip section navigation (2)

Re: Error in using copy command

From: Michael Wood <esiotrot(at)gmail(dot)com>
To: Sindile Bidla <sindile(dot)bidla(at)gmail(dot)com>
Cc: pgsql-novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Error in using copy command
Date: 2011-05-11 13:42:21
Message-ID: BANLkTimHF88g9ukEkdTkDCAUWzkMT=sZRw@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
On 11 May 2011 15:07, Sindile Bidla <sindile(dot)bidla(at)gmail(dot)com> wrote:
> I have modified my command to: COPY tablename FROM 'myfile' DELIMITER ','
> CSV QUOTE '"' ESCAPE E'\\';
> following your suggestion but I am still getting the same error

What is the table definition?

> On 11 May 2011 14:34, Michael Wood <esiotrot(at)gmail(dot)com> wrote:
>>
>> On 11 May 2011 14:28, Michael Wood <esiotrot(at)gmail(dot)com> wrote:
>> > On 11 May 2011 14:09, Sindile Bidla <sindile(dot)bidla(at)gmail(dot)com> wrote:
>> >>
>> >> 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 ',';
>> >
>> > Try:
>> >
>> > COPY tablename FROM 'myfile'
>> > DELIMITER ','
>> > CSV QUOTE '"' ESCAPE '\';
>> >
>> > (ESCAPE might be wrong depending on what your CSV looks like if one of
>> > the fields contains a " character.)
>>
>> Sorry, should be:
>>
>> ...
>> ESCAPE E'\\'
>>
>> if you want to use a single \ as an escape character.

-- 
Michael Wood <esiotrot(at)gmail(dot)com>

In response to

Responses

pgsql-novice by date

Next:From: Sindile BidlaDate: 2011-05-11 16:11:06
Subject: Re: Error in using copy command
Previous:From: Sindile BidlaDate: 2011-05-11 13:07:15
Subject: Re: Error in using copy command

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group