X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 19BC1D7352; Wed, 31 Aug 2005 12:14:19 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 68621-02; Wed, 31 Aug 2005 15:14:12 +0000 (GMT) Received: from obelix.askesis.nl (laudanum.demon.nl [82.161.125.16]) by svr1.postgresql.org (Postfix) with ESMTP id 9DB03D7292; Wed, 31 Aug 2005 12:14:10 -0300 (ADT) Received: obelix.askesis.nl 172.31.0.1 from 172.31.1.8 172.31.1.8 via HTTP with MS-WebStorage 6.0.6249 Received: from Panoramix by obelix.askesis.nl; 31 Aug 2005 17:14:08 +0200 Subject: Re: [SQL] How do I copy part of table from db1 to db2 From: Joost Kraaijeveld To: Tom Lane Cc: Roman Neuhauser , "Pgsql-sql@postgresql.org" , Pgsql-General In-Reply-To: <1677.1125498589@sss.pgh.pa.us> References: <1125482430.9456.6.camel@Panoramix> <20050831104011.GB74859@isis.sigpipe.cz> <1125489603.9456.24.camel@Panoramix> <1677.1125498589@sss.pgh.pa.us> Content-Type: text/plain Content-Transfer-Encoding: 7bit Date: Wed, 31 Aug 2005 17:14:08 +0200 Message-Id: <1125501248.9456.74.camel@Panoramix> Mime-Version: 1.0 X-Mailer: Evolution 2.0.4 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.089 required=5 tests=[AWL=0.039, FORGED_RCVD_HELO=0.05] X-Spam-Level: X-Archive-Number: 200508/1578 X-Sequence-Number: 82986 On Wed, 2005-08-31 at 10:29 -0400, Tom Lane wrote: > Joost Kraaijeveld writes: > If, as seems more likely, there's a mishmash of different encodings then > you are in for some pain. At the minimum you'll have to separate out Yep. The original database (which is copied to an SQL-ASCII PostgreSQL database) is a mishmash of encodings. Actually no official encoding is given for the database. But I managed to get an acceptable (for me that is) import, only losing all the diacritical chars for this moment (see other mail) Thanks for responding, Joost.