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:[EMAIL PROTECTED]
Sent: Fri 10/15/2004 8:25 AM
To: Jason Tesser
Cc: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] on behalf of Jason Tesser
> Sent: Wed 10/13/2004 10:00 AM
> To: [EMAIL PROTECTED]
> 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"
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match