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@dcc.uchile.cl]
Sent: Fri 10/15/2004 8:25 AM
To: Jason Tesser
Cc: pgsql-general@postgresql.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@postgresql.org on behalf of Jason Tesser
> Sent: Wed 10/13/2004 10:00 AM
> To: pgsql-general@postgresql.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"