Re: Howto read a UTF-8 CSV with COPY?

Andreas,

Have you looked at using pgloader?

http://pgloader.projects.postgresql.org

Also did you save the MS Office file as a simple plain text file?

I'm a novice myself but do know that this offers slightly more advanced
options than the simple COPY utility.

On Thu, Nov 11, 2010 at 10:01 PM, Andreas <maps(dot)on(at)gmx(dot)net> wrote:

> Hi,
> I'd like to import some data from ms-office that has text columns with
> international characters in it.
>
> COPY complains about illegal byte sequences.
>
> When I placed a "set client_encoding = LATIN1" in front of the COPY
> command, COPY was happy.
> It still didn't work as expected. There were empty attributes in the
> imported table when there were accent decorated characters in the source
> file.
>
> Is there a way to import UTF8 encoded csv files ?
>
> --
> Sent via pgsql-novice mailing list (pgsql-novice(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-novice
>