Simplified steps to reproduce the issue:
1. CREATE TABLE TEST (description varchar(10));
2. Insert value 'Galaxy\040Tab' using command COPY TEST(description) FROM stdin WITH DELIMITER '|' CSV.
The following error is returned: value too long for type character varying(10)
Of course real life scenarios are more complex and different characters were used (\042 and \005).
Is this a bug, or an incorrect use of COPY/CSV?
Thank you
Konstantin
