Re: converting database to unicode

Uhh no. Could you help me understand how to do that. I am currently using the following to dump and restore
pg_dump -Fc --username=xxx --dbanme=xxx filename
pg_restore -Fc --username=xxx --dbname filename

-----Original Message-----
From: Alvaro Herrera [mailto:alvherre(at)dcc(dot)uchile(dot)cl]
Sent: Fri 10/15/2004 8:25 AM
To: Jason Tesser
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] converting database to unicode

On Fri, Oct 15, 2004 at 07:59:19AM -0500, Jason Tesser wrote:
> Some help please?? :-) Anyone?

Did you try recoding the plain-text dump using recode or iconv?


> -----Original Message-----
> From: pgsql-general-owner(at)postgresql(dot)org on behalf of Jason Tesser
> Sent: Wed 10/13/2004 10:00 AM
> To: pgsql-general(at)postgresql(dot)org
> Cc:
> Subject: [GENERAL] converting database to unicode
> I have a database in sql_ascii that I need to convert to Unicode. I tried using
> pg_dump -Fc .. but it fails on certain characters. like this one "è"
> How can I get the data transferred?

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"No es bueno caminar con un hombre muerto"