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 7D17BD8527;
	Wed, 31 Aug 2005 09:00:12 -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 19421-05; Wed, 31 Aug 2005 12:00:09 +0000 (GMT)
Received: from obelix.askesis.nl (laudanum.demon.nl [82.161.125.16])
	by svr1.postgresql.org (Postfix) with ESMTP id 3AB6BD83C5;
	Wed, 31 Aug 2005 09:00:06 -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 14:00:03 +0200
Subject: Re: How do I copy part of table from db1 to db2 (and
From: Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>
To: Roman Neuhauser <neuhauser@sigpipe.cz>
Cc: "Pgsql-sql@postgresql.org" <Pgsql-sql@postgresql.org>,
	Pgsql-General <pgsql-general@postgresql.org>
In-Reply-To: <20050831104011.GB74859@isis.sigpipe.cz>
References: <1125482430.9456.6.camel@Panoramix>
	<20050831104011.GB74859@isis.sigpipe.cz>
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable
Date: Wed, 31 Aug 2005 14:00:03 +0200
Message-Id: <1125489603.9456.24.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.092 required=5 tests=[AWL=0.042,
	FORGED_RCVD_HELO=0.05]
X-Spam-Level: 
X-Archive-Number: 200508/1565
X-Sequence-Number: 82973

On Wed, 2005-08-31 at 12:40 +0200, Roman Neuhauser wrote:
>     check these man pages: pg_dump(1), pg_restore(1), alter_table(7)

I am afraid that the problem is more complex. The original database (which =
is created with SQL_ASCII) contains invalid byte sequences in some columns =
(target database created with UNICODE):

jkr@Panoramix:~/postgresql$  pg_dump -t artik munttest | psql muntfinal
> output.txt
ERROR:  invalid byte sequence for encoding "UNICODE": 0xeb207a
CONTEXT:  COPY artik, line 11705, column omschrijving: "Anna v. Groot
Brittanni=EB zi prf 38.61 mm"

So I cannot dump/restore/alter table. I was hoping that piping the text
from stdout to psql that a valid conversion to unicode would take place
but apparently that is not the case.

Any other ideas?

Joost