pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: lms <piechcio@inetcafe.eu.org>
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> (raw)
In-Reply-To: <cf9b4f3e0611190715p2e43ee42wcf8e5e5768b784cc@mail.gmail.com>
References: <20061117165852.M2045@isb.com.pl>
	<cf9b4f3e0611171111n22e4b1c1k8f1bf0de151fd31a@mail.gmail.com>
	<20061117230302.M62231@inetcafe.eu.org>
	<cf9b4f3e0611180642s316340ddrd597809048786b63@mail.gmail.com>
	<20061119003111.M86685@inetcafe.eu.org>
	<cf9b4f3e0611190715p2e43ee42wcf8e5e5768b784cc@mail.gmail.com>

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 





view thread (6+ messages)

Message-ID: <20061120182610.M33386@inetcafe.eu.org>
Permalink:  ../20061120182610.M33386@inetcafe.eu.org/
Also on:    postgresql.org/message-id/20061120182610.M33386@inetcafe.eu.org

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: piechcio@inetcafe.eu.org
  Subject: Re: How convert UNICODE
  In-Reply-To: <20061120182610.M33386@inetcafe.eu.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox