I am trying to import a csv file to postgres db. I tried first through pgadmin tool and got error - ERROR: unterminated CSV quoted field.
Then i imported it through command - \copy table FROM filename DELIMITER ',' CSV ENCODING 'UTF8' QUOTE E'\b' ESCAPE '''';
then got error -
ERROR: extra data after last expected column
I checked even.. there are no extra data after last column. Both files and my table in DB has 6 columns.
CREATE TABLE STATEMENT :
CREATE TABLE public.test_table (
classification character varying(255) COLLATE pg_catalog."default",
code character varying(255) COLLATE pg_catalog."default",
desc character varying(255) COLLATE pg_catalog."default",
startDate date, jurisdiction character varying(255)
COLLATE pg_catalog."default", endDate date )
What can be the issue. Can someone help?