Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] How do I copy part of table from db1 to db2 (and - Mailing list pgsql-sql

From Thomas Pundt
Subject Re: [GENERAL] How do I copy part of table from db1 to db2 (and
Date
Msg-id 200508311409.16106.mlists@rp-online.de
Whole thread Raw
In response to Re: [GENERAL] How do I copy part of table from db1 to db2 (and  (Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>)
Responses Re: [GENERAL] How do I copy part of table from db1 to db2 (and  (Thomas Pundt <mlists@rp-online.de>)
List pgsql-sql
Tree view 
On Wednesday 31 August 2005 14:00, Joost Kraaijeveld wrote:
| 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?

maybe the "recode" utility can help then? Something like

  pg_dump -t artik munttest | recode latin1..utf | psql muntfinal

Ciao,
Thomas

--
Thomas Pundt <thomas.pundt@rp-online.de> ---- http://rp-online.de/ ----

pgsql-sql by date:

Previous
From: Joost Kraaijeveld
Date:
Subject: Re: [GENERAL] How do I copy part of table from db1 to db2 (and
Next
From: Thomas Pundt
Date:
Subject: Re: [GENERAL] How do I copy part of table from db1 to db2 (and