| 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 |