Excellent - Thanks John - I'll give that a crack.
Any idea why the --encoding flag didn't do this via pg_dump?
On 5/15/07, John DeSoi <desoi(at)pgedit(dot)com> wrote:
> You'll probably need to dump the database as SQL_ASCII (in text
> format) and then use a program like iconv (http://en.wikipedia.org/
> wiki/Iconv) to fix it so that it is valid UTF8.
> On May 14, 2007, at 5:23 PM, Neil Saunders wrote:
> > I'm at temping to migrate a database from a Windows installation
> > (8.1.4) to a Linux installation (8.2.4). I've successfully migrated
> > the schema, but now am running in to difficulties importing the data.
> John DeSoi, Ph.D.
> Power Tools for PostgreSQL
In response to
pgsql-novice by date
|Next:||From: Richard Broersma Jr||Date: 2007-05-15 21:59:52|
|Subject: Re: aggregate function ?|
|Previous:||From: Raimon Fernandez||Date: 2007-05-15 20:56:37|
|Subject: aggregate function ?|