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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-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/ ----
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas Pundt | 2005-08-31 12:14:26 | Re: [SQL] How do I copy part of table from db1 to db2 (and |
Previous Message | Patrick.FICHE | 2005-08-31 12:05:12 | Re: Removing all users from a group |
From | Date | Subject | |
---|---|---|---|
Next Message | digit-x | 2005-08-31 12:14:06 | psql commandline |
Previous Message | Joost Kraaijeveld | 2005-08-31 12:00:03 | Re: How do I copy part of table from db1 to db2 (and |