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.