Postgres Pro
Downloads
Home   >   mailing lists

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

From Thomas Pundt
Subject Re: [SQL] How do I copy part of table from db1 to db2 (and
Date
Msg-id 200508311414.26431.mlists@rp-online.de
Whole thread Raw
In response to Re: [SQL] How do I copy part of table from db1 to db2 (and  (Thomas Pundt <mlists@rp-online.de>)
Responses Re: [SQL] How do I copy part of table from db1 to db2  (Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>)
List pgsql-general
Tree view 
On Wednesday 31 August 2005 14:09, Thomas Pundt wrote:
| maybe the "recode" utility can help then? Something like
|
|   pg_dump -t artik munttest | recode latin1..utf | psql muntfinal

sorry to follow up on myself, but that command should read

  pg_dump -t artik munttest | recode latin1..utf8 | psql muntfinal
                                             ^^^^
(utf is not a valid "recode" charset, utf8 is).

Ciao,
Thomas

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

pgsql-general by date:

Previous
From: Thomas Pundt
Date:
Subject: Re: [SQL] How do I copy part of table from db1 to db2 (and
Next
From: Patrick.FICHE@AQSACOM.COM
Date:
Subject: Re: Removing all users from a group