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>