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 968CFD864A;
	Wed, 31 Aug 2005 12:02:29 -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 65574-02; Wed, 31 Aug 2005 15:02:25 +0000 (GMT)
Received: from obelix.askesis.nl (laudanum.demon.nl [82.161.125.16])
	by svr1.postgresql.org (Postfix) with ESMTP id D0FBCD860C;
	Wed, 31 Aug 2005 12:02:20 -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:02:17 +0200
Subject: Re: [SQL] How do I copy part of table from db1 to db2
From: Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>
To: Thomas Pundt <mlists@rp-online.de>
Cc: "Pgsql-sql@postgresql.org" <Pgsql-sql@postgresql.org>,
	Pgsql-General <pgsql-general@postgresql.org>
In-Reply-To: <200508311414.26431.mlists@rp-online.de>
References: <1125482430.9456.6.camel@Panoramix>
	<1125489603.9456.24.camel@Panoramix>
	<200508311409.16106.mlists@rp-online.de>
	<200508311414.26431.mlists@rp-online.de>
Content-Type: text/plain
Content-Transfer-Encoding: 7bit
Date: Wed, 31 Aug 2005 17:02:17 +0200
Message-Id: <1125500537.9456.68.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.09 required=5 tests=[AWL=0.040,
	FORGED_RCVD_HELO=0.05]
X-Spam-Level: 
X-Archive-Number: 200508/1577
X-Sequence-Number: 82985

On Wed, 2005-08-31 at 14:14 +0200, Thomas Pundt wrote:

>   pg_dump -t artik munttest | recode latin1..utf8 | psql muntfinal
Because the source encoding is unknown (the actual source database was
an ODBC source without known encoding that was copied with a C++ written
to a SQL_ASCII PostgreSQL database) I used no source encoding:

"pg_dump -t artik munttest | recode ..utf8 | psql muntfinal"

and that worked: no errors. I just lost all diacritical chars as far as
I can see (which is a minor and someone else's problem ;-)). 

Thanks for the sugggestion.

Joost