hello I am trying to import a csv file into one of my tables in my pg admin database but keep this reoccurring error.
COPY CO_ROADS
FROM 'C:\Users\Geog\Documents\corut.csv' DELIMITER ',' CSV_HEADER;
ERROR: malformed array literal: "2.07" DETAIL: Array value must start with "{" or dimension information. CONTEXT: COPY co_roads, line 2, column ACRES: "2.07"
This is confusing since the data type of the column is an integer.
any advice? thank you!
I tried getting rid of unnecessary columns and using a comma as a delimiter for the csv. No avail though.