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@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"