| From: | Joost Kraaijeveld <J(dot)Kraaijeveld(at)Askesis(dot)nl> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Roman Neuhauser <neuhauser(at)sigpipe(dot)cz>, "Pgsql-sql(at)postgresql(dot)org" <Pgsql-sql(at)postgresql(dot)org>, Pgsql-General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: [SQL] How do I copy part of table from db1 to db2 |
| Date: | 2005-08-31 15:14:08 |
| Message-ID: | 1125501248.9456.74.camel@Panoramix |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-sql |
On Wed, 2005-08-31 at 10:29 -0400, Tom Lane wrote:
> Joost Kraaijeveld <J(dot)Kraaijeveld(at)Askesis(dot)nl> writes:
> If, as seems more likely, there's a mishmash of different encodings then
> you are in for some pain. At the minimum you'll have to separate out
Yep. The original database (which is copied to an SQL-ASCII PostgreSQL
database) is a mishmash of encodings. Actually no official encoding is
given for the database.
But I managed to get an acceptable (for me that is) import, only losing
all the diacritical chars for this moment (see other mail)
Thanks for responding,
Joost.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Marlowe | 2005-08-31 15:35:12 | Re: detection of VACUUM in progress |
| Previous Message | Joost Kraaijeveld | 2005-08-31 15:02:17 | Re: [SQL] How do I copy part of table from db1 to db2 |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2005-08-31 15:22:21 | Re: insert only if conditions are met? |
| Previous Message | Henry Ortega | 2005-08-31 15:09:54 | insert only if conditions are met? |