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