HelloThanks for help. Iconv is good. Now I use iconv function with libpq.
On Sun, 19 Nov 2006 10:15:53 -0500, Travis Whitton wrote
> Assuming you're on a Unix based platform:
>
> psql> COPY tablename (column1) TO 'column1.csv' WITH CSV;
>
> bash> iconv -f UTF-8 -t iso8859_2 column1.csv > iconv-column1.csv
>
> psql> COPY tablename (column2) TO ' column2.csv' WITH CSV;
>
> bash> iconv -f UTF-8 -t iso8859_5 column2.csv > iconv-column2.csv
>
> repeat for each column...
>
> bash> paste iconv-column* > newtable.csv