Unanswered: Invalid byte sequence for encoding “UTF8”
I have to upload a csv file of more than 2GB . I get the following error : Invalid byte sequence for encoding “UTF8”....
I can not open the file to know the char that generates this error. Some one happened?
copy places_staging FROM 'path_file/1.csv' DELIMITER AS '|';
your csv-file contains byte sequences which are not defined in UTF-8. That says the error message. That happens when you have bytes from above the ASCII-range, that is higher than 127 - e.g. umlauts, signs with carets, cedils etc.
In that case tell the database the correct encoding. If you use psql then enter \encoding followed with the correct encoding.