Skip site navigation (1) Skip section navigation (2)

Re: [SQL] How do I copy part of table from db1 to db2 (and

From: Thomas Pundt <mlists(at)rp-online(dot)de>
To: pgsql-sql(at)postgresql(dot)org,Joost Kraaijeveld <J(dot)Kraaijeveld(at)askesis(dot)nl>,Pgsql-General <pgsql-general(at)postgresql(dot)org>
Subject: Re: [SQL] How do I copy part of table from db1 to db2 (and
Date: 2005-08-31 12:09:15
Message-ID: 200508311409.16106.mlists@rp-online.de (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-sql
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(dot)pundt(at)rp-online(dot)de> ---- http://rp-online.de/ ----


In response to

Responses

pgsql-sql by date

Next:From: digit-xDate: 2005-08-31 12:14:06
Subject: psql commandline
Previous:From: Joost KraaijeveldDate: 2005-08-31 12:00:03
Subject: Re: How do I copy part of table from db1 to db2 (and

pgsql-general by date

Next:From: Thomas PundtDate: 2005-08-31 12:14:26
Subject: Re: [SQL] How do I copy part of table from db1 to db2 (and
Previous:From: Patrick.FICHEDate: 2005-08-31 12:05:12
Subject: Re: Removing all users from a group

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group