[GENERAL] convert database to unicode

2003-08-26 Thread David Lutz
Hello, I want to convert an existing database with SQL_ASCII encoding to UNICODE encoding. (postgresql ver 7.3.2) I thought that it might be as easy as: pg_dump mydatabase > dump.sql createdb --encoding=unicode newdatabase psql newdatabase < dump.sql but it wasn't going to be that easy now was

Re: [GENERAL] convert database to unicode

2003-08-26 Thread David Lutz
--- Gianni Mariani <[EMAIL PROTECTED]> wrote: > David Lutz wrote: > > >Hello, I want to convert an existing database with > >SQL_ASCII encoding to UNICODE encoding. > > > >(postgresql ver 7.3.2) > > > >I thought that it might be as easy