Re: Something like pg_dump for 7.4

From: Artur Pietruk <arturp(at)plukwa(dot)net>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Something like pg_dump for 7.4
Date: 2006-02-17 07:48:50
Message-ID: 20060217074850.GA19843@plukwa.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Thu, Feb 16, 2006 at 09:11:13PM -0800, Gregory S. Williamson wrote:
> See that double space after "Media" ? That's actually a single space, a dash, and another space: "XYZ Media - AB&E", but every export turns it into:
> XYZ Media <96> AB&E

I'm not sure if I got your problem correctly here - but if you
really want to just replace " <96> " with " - ", then maybe do it with a
small sed script? Like sed -f mysed.sed mydump >mydump_fixed, where
mysed would be:

===8<===
s/ <96> / - /g
===8<===

Just make sure <96> is the real char copy/pasted from the source
- you could copy it e.g. by opening vi with two windows, one with
'mydump', and another with 'mysed.sed'

But it does not guarantee there are no other broken chars in
your dump. But catching them one by one, and getting also help with
iconv as Tom mentioned, you should be able to fix that - good luck!

--
--- Artur Pietruk, arturp(at)plukwa(dot)net

Browse pgsql-admin by date

  From Date Subject
Next Message Gregory S. Williamson 2006-02-17 08:58:41 Re: Something like pg_dump for 7.4
Previous Message Tom Lane 2006-02-17 06:19:35 Re: Something like pg_dump for 7.4