Received: from localhost (pluto.hub.org [200.46.204.4]) by postgresql.org (Postfix) with ESMTP id DB2109FA333 for ; Mon, 20 Nov 2006 19:16:18 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.4]) (amavisd-new, port 10024) with ESMTP id 16774-01-7 for ; Mon, 20 Nov 2006 19:16:07 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 7200A9FB1E7 for ; Mon, 20 Nov 2006 19:15:19 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from isb.com.pl (poczta.isb.com.pl [80.48.198.2]) by svr4.postgresql.org (Postfix) with ESMTP id AE9B95AFA10 for ; Mon, 20 Nov 2006 18:24:57 +0000 (GMT) Received: from localhost (localhost.localdomain [127.0.0.1]) by isb.com.pl (Postfix) with ESMTP id A5012B13B4 for ; Mon, 20 Nov 2006 19:28:20 +0100 (CET) Received: from isb.com.pl ([127.0.0.1]) by localhost (isb.com.pl [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 24761-09 for ; Mon, 20 Nov 2006 19:28:19 +0100 (CET) Received: from mail.isb.com.pl (localhost.localdomain [127.0.0.1]) by isb.com.pl (Postfix) with ESMTP id 56739B13B1 for ; Mon, 20 Nov 2006 19:28:19 +0100 (CET) From: "lms" To: pgsql-sql@postgresql.org Subject: Re: How convert UNICODE Date: Mon, 20 Nov 2006 19:28:19 +0100 Message-Id: <20061120182610.M33386@inetcafe.eu.org> In-Reply-To: References: <20061117165852.M2045@isb.com.pl> <20061117230302.M62231@inetcafe.eu.org> <20061119003111.M86685@inetcafe.eu.org> X-Mailer: Open WebMail 2.50 20050106 X-OriginatingIP: 80.48.198.7 (piechcio) MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-2 X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at isb.com.pl X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/217 X-Sequence-Number: 26869 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