From: | Sindile Bidla <sindile(dot)bidla(at)gmail(dot)com> |
---|---|
To: | pgsql-novice <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: Error in using copy command |
Date: | 2011-05-11 13:07:15 |
Message-ID: | BANLkTimGsi6v18DZjHO7A-G6A36hGtjGNQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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
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>
>
--
Sindile Bidla
Tel: 0823408538
Fax: 0865246419
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Wood | 2011-05-11 13:42:21 | Re: Error in using copy command |
Previous Message | Michael Wood | 2011-05-11 12:34:51 | Re: Error in using copy command |