Re: Something like pg_dump for 7.4 - Mailing list pgsql-admin

From Artur Pietruk
Subject Re: Something like pg_dump for 7.4
Date
Msg-id 20060217074850.GA19843@plukwa.net
Whole thread Raw
In response to Something like pg_dump for 7.4  ("Gregory S. Williamson" <gsw@globexplorer.com>)
List 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",
butevery 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@plukwa.net

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Something like pg_dump for 7.4
Next
From: "Gregory S. Williamson"
Date:
Subject: Re: Something like pg_dump for 7.4