Обсуждение: Error in using copy command
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 ',';
On 11 May 2011 14:09, Sindile Bidla <sindile.bidla@gmail.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.) -- Michael Wood <esiotrot@gmail.com>
On 11 May 2011 14:28, Michael Wood <esiotrot@gmail.com> wrote: > On 11 May 2011 14:09, Sindile Bidla <sindile.bidla@gmail.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@gmail.com>
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
--
Sindile Bidla
Tel: 0823408538
Fax: 0865246419
On 11 May 2011 14:34, Michael Wood <esiotrot@gmail.com> wrote:
Sorry, should be:On 11 May 2011 14:28, Michael Wood <esiotrot@gmail.com> wrote:
> On 11 May 2011 14:09, Sindile Bidla <sindile.bidla@gmail.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.)
...
ESCAPE E'\\'
if you want to use a single \ as an escape character.
--
Sindile Bidla
Tel: 0823408538
Fax: 0865246419
On 11 May 2011 15:07, Sindile Bidla <sindile.bidla@gmail.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@gmail.com> wrote: >> >> On 11 May 2011 14:28, Michael Wood <esiotrot@gmail.com> wrote: >> > On 11 May 2011 14:09, Sindile Bidla <sindile.bidla@gmail.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@gmail.com>
It works and thank you
On 11 May 2011 15:42, Michael Wood <esiotrot@gmail.com> wrote:
On 11 May 2011 15:07, Sindile Bidla <sindile.bidla@gmail.com> wrote:What is the table definition?
> 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@gmail.com> wrote:
>>
>> On 11 May 2011 14:28, Michael Wood <esiotrot@gmail.com> wrote:
>> > On 11 May 2011 14:09, Sindile Bidla <sindile.bidla@gmail.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@gmail.com>