Re: How convert UNICODE

From: "lms" <piechcio(at)inetcafe(dot)eu(dot)org>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: How convert UNICODE
Date: 2006-11-20 18:28:19
Message-ID: 20061120182610.M33386@inetcafe.eu.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hello
Thanks 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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Abdul Wahab Dahalan 2006-11-21 01:35:13 Embedded mySQL
Previous Message Richard Broersma Jr 2006-11-20 17:57:41 Re: How to find out top 3 records in each location