On Thu, Feb 26, 2015 at 9:50 PM, Melvin Call <melvincall...@gmail.com>
wrote:

> Montreal where the e is an accented e. The output ends up in the text file
> as
> Montr\xe9al, where the xe9 is a single character. When I try to copy that
> into
> my PostgreSQL table, I get an error "ERROR:  invalid byte sequence for
> encoding
>

Character code E9 is not UTF8. Don't tell Postgres you're importing UTF8 if
you're not.

Reply via email to