Hi everyone. I'm running postgresql 7.4 and I'm trying to import some data from a CSV file using this command:
COPY vendor (vc, vname, address, city, state, zip, phone, rent_to_vc)
FROM '/home/nabil/vendordata.csv' DELIMITER ',';
but I get an error:
ERROR: malformed array literal: "{109 URBAN AVENUE"
SQL state: 22P02
Context: COPY vendor, line 2, column address: "{109 URBAN AVENUE"
the data line is:
AB00045,GOES KING,{109 URBAN AVENUE,},WESTBURY,NY,11590-4800,800-524-1556,1
and the code for the address column:
ALTER TABLE vendor ADD COLUMN address character varying(30)[];
ALTER TABLE vendor ALTER COLUMN address SET STORAGE EXTENDED;
ALTER TABLE vendor ALTER COLUMN address SET NOT NULL;
^ copied from the SQL pane in pgAdmin
I dont know why I'm getting this error... If I remove the comma at the end of AVENUE the error goes away but I created the address column with a data type of varchar(30)[2]. Does any one know what I'm doing wrong?