Re: Import db from 8.1.3 to 8.3.1

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Cc: Andrew Sullivan <ajs(at)commandprompt(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Import db from 8.1.3 to 8.3.1
Date: 2008-10-23 18:03:01
Message-ID: 11640.1224784981@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Alvaro Herrera <alvherre(at)commandprompt(dot)com> writes:
> Andrew Sullivan wrote:
>> I expect that your problem is that 8.1 allowed some characters in that
>> you didn't want. You probably need to use iconv to change those
>> characters to whatever are actually valid.

> \x09 is a tab. I think this behavior was changed in 8.3.something (made
> it display as actual tabs instead of escaping them)

Note that that's a psql behavior not a backend behavior. I wonder if
the OP updated his server but is still using 8.3.early psql.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Angel Alvarez 2008-10-23 18:09:04 Re: Annoying Reply-To
Previous Message Sam Mason 2008-10-23 18:01:13 Re: Storing questionnaire data