Re: Frustrated...pg_dump/restore

From: Jeff Amiel <becauseimjeff(at)yahoo(dot)com>
To: ries van Twisk <pg(at)rvt(dot)dds(dot)nl>, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
Cc: PGSQL <pgsql-general(at)postgresql(dot)org>
Subject: Re: Frustrated...pg_dump/restore
Date: 2008-10-06 15:26:49
Message-ID: 156429.57632.qm@web65504.mail.ac4.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

--- On Mon, 10/6/08, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> wrote:

> I'm wondering if the OP has some line breaks in his
> data that are
> getting misinterpreted, or maybe his encoding on the two
> dbs is
> different and he's not taking care of that.

Ahhh....
*looks at encoding*

Well..they are both the same...BUT...they are set to
ENCODING = 'SQL_ASCII';

That explains a lot....they should probably be set to Unicode UTF8....
Duh!!!!

Any way to change encoding without dumping/restoring database?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2008-10-06 15:28:20 Re: function returning setof..select versus select * from
Previous Message Keaton Adams 2008-10-06 15:26:03 Clarification on documentation