| 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:14:26 |
| Message-ID: | 200508311414.26431.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: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(dot)pundt(at)rp-online(dot)de> ---- http://rp-online.de/ ----
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bohdan Linda | 2005-08-31 12:18:47 | Re: detection of VACUUM in progress |
| Previous Message | Thomas Pundt | 2005-08-31 12:09:15 | Re: [SQL] How do I copy part of table from db1 to db2 (and |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | dIGITx | 2005-08-31 12:18:31 | psql commandline |
| Previous Message | digit-x | 2005-08-31 12:14:06 | psql commandline |