From: Artur Pietruk <arturp@plukwa.net>
To: pgsql-admin@postgresql.org
Subject: Re: Something like pg_dump for 7.4
Date: Fri, 17 Feb 2006 08:48:50 +0100
Message-ID: <20060217074850.GA19843@plukwa.net> (raw)
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@plukwa.net
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: arturp@plukwa.net
Subject: Re: Something like pg_dump for 7.4
In-Reply-To: <20060217074850.GA19843@plukwa.net>
References: <20060217074850.GA19843@plukwa.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox