| From: | Joost Kraaijeveld <J(dot)Kraaijeveld(at)Askesis(dot)nl> |
|---|---|
| To: | Roman Neuhauser <neuhauser(at)sigpipe(dot)cz> |
| Cc: | "Pgsql-sql(at)postgresql(dot)org" <Pgsql-sql(at)postgresql(dot)org>, Pgsql-General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: How do I copy part of table from db1 to db2 (and |
| Date: | 2005-08-31 12:00:03 |
| Message-ID: | 1125489603.9456.24.camel@Panoramix |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-sql |
On Wed, 2005-08-31 at 12:40 +0200, Roman Neuhauser wrote:
> check these man pages: pg_dump(1), pg_restore(1), alter_table(7)
I am afraid that the problem is more complex. The original database (which is created with SQL_ASCII) contains invalid byte sequences in some columns (target database created with UNICODE):
jkr(at)Panoramix:~/postgresql$ pg_dump -t artik munttest | psql muntfinal
> output.txt
ERROR: invalid byte sequence for encoding "UNICODE": 0xeb207a
CONTEXT: COPY artik, line 11705, column omschrijving: "Anna v. Groot
Brittannië zi prf 38.61 mm"
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?
Joost
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Patrick.FICHE | 2005-08-31 12:05:12 | Re: Removing all users from a group |
| Previous Message | Oleg Bartunov | 2005-08-31 11:10:04 | Re: Searching for LTree dmoz-testdata |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas Pundt | 2005-08-31 12:09:15 | Re: [SQL] How do I copy part of table from db1 to db2 (and |
| Previous Message | Roman Neuhauser | 2005-08-31 10:40:11 | Re: How do I copy part of table from db1 to db2 (and rename the columns)? |