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 ',';