convert database to unicode

From: David Lutz <dlutzy(at)yahoo(dot)com(dot)au>
To: pgsql-general(at)postgresql(dot)org
Subject: convert database to unicode
Date: 2003-08-26 05:14:13
Message-ID: 20030826051413.14268.qmail@web13907.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 it :-(

I'm getting errors such as:
ERROR: copy: line 54, Invalid UNICODE character
sequence found (0xe46765)
lost synchronization with server, resetting connection

Can anyone suggest a way I might be able to do it?
Thanks, David

http://search.yahoo.com.au - Yahoo! Search
- Looking for more? Try the new Yahoo! Search

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Curt Sampson 2003-08-26 05:19:47 Re: [HACKERS] Decent VACUUM (was: Buglist)
Previous Message Bruce Momjian 2003-08-26 04:37:00 Re: Buglist