X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 568129DCB48 for ; Fri, 17 Feb 2006 03:49:12 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 59045-02 for ; Fri, 17 Feb 2006 03:49:12 -0400 (AST) Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 43BA29DCB46 for ; Fri, 17 Feb 2006 03:49:10 -0400 (AST) Received: from coruscant.plukwa.net (coruscant.plukwa.net [195.28.178.197]) by svr4.postgresql.org (Postfix) with ESMTP id AF3215AF0D8 for ; Fri, 17 Feb 2006 07:49:11 +0000 (GMT) Received: from arturp by coruscant.plukwa.net with local (Exim 4.60) (envelope-from ) id 1FA0ME-0005AR-Hx for pgsql-admin@postgresql.org; Fri, 17 Feb 2006 08:48:50 +0100 Date: Fri, 17 Feb 2006 08:48:50 +0100 From: Artur Pietruk To: pgsql-admin@postgresql.org Subject: Re: Something like pg_dump for 7.4 Message-ID: <20060217074850.GA19843@plukwa.net> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.5.11 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200602/208 X-Sequence-Number: 20629 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