Hello,
I am trying to copy a table from a file:
COPY table FROM 'file/path/filename.csv' DELIMITER ';' CSV;
But I got this error:
ERROR: value too long for type character varying(8)
SQL state: 22001
Context: COPY $tablename, line 1, column $colum_name: "69900900"
Look that the length of the data (69900900) i want to copy fits the column data type (varchar(8)). The length is exactly the same.
The file is well formatted and Encoded in UTF-8:
value1;value2;value3;value4
Someone know what i'm doing wrong?
Thank you.