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

Reply via email to