Re: COPY-ing ASCII file into UTF-8 database - Mailing list pgsql-admin

From Tommy Gildseth
Subject Re: COPY-ing ASCII file into UTF-8 database
Date
Msg-id 49D9A769.8020609@usit.uio.no
Whole thread Raw
In response to COPY-ing ASCII file into UTF-8 database  (Toomas Vendelin <pg@vendelin.com>)
List pgsql-admin
Toomas Vendelin wrote:
>
> MY QUESTIONS:
>
> 1. What is the proper solution for importing data from plain ASCII
> files, that contain the type of characters mentioned above?

Set the correct client_encoding, before importing. Presumably the
Estonian characters are part of one of the flavours of LATIN 1-9

 > SET CLIENT_ENCODING='LATIN<X>'; -- Where you substitute <X> for the
correct number
 > \copy ....

--
Tommy Gildseth

pgsql-admin by date:

Previous
From: Toomas Vendelin
Date:
Subject: COPY-ing ASCII file into UTF-8 database
Next
From: Dimitri Fontaine
Date:
Subject: Re: how to do prefix_range default value?