Character with encoding UTF8 has no equivalent in WIN1252
I had a similar issue, and I solved by setting the encoding to UTF8 with \encoding UTF8 in the client before attempting an INSERT INTO foo (SELECT * from bar WHERE x=y);. My client was using WIN1252 encoding but the database was in UTF8, hence the error. More info is available on the PostgreSQL wiki … Read more