Hello Folks,
we had this topic before on this list.
This is is a new error with the same message.
I tried to copy from a text file and a csv file with the same issue.
the integer values are not quoted in the file
source:
3192;95956;48901;1018;NULL;Мурзилка;3;2006-
\copy abos from '/Users/jreiners/Downloads/test.csv' (format csv, delimiter ';', encoding 'utf-8');
ERROR: invalid input syntax for integer: "3192"
Source:
3192 95956 48901 1018 NULL Мурзилка 3 2006-
\copy abos from '/Users/jreiners/Downloads/text.txt' (encoding 'utf-8', null 'NULL');
ERROR: invalid input syntax for integer: "3192"
I couldn't find any clues. Please help me.
Kind regards,
Jonatan