how to dump and restore unicode databases?
От | Andreas Schuldei |
---|---|
Тема | how to dump and restore unicode databases? |
Дата | |
Msg-id | 20021217224818.GA10840@lukas обсуждение исходный текст |
Список | pgsql-admin |
i have two machines, one with postgres 7.2.X and one with 7.3. Both their encodings are set to UNICODE. on the first i have crated a unicode database, with german, swedish and english texts, more to come. on that machine i dump the db with pg_dump -c -s ncg and pg_dump -D -a ncg. on that machine i can restore the structure and data of the database just fine. I also edit the dump to use the coziness of my texteditor to add larger amounts of text. i can restore those edited dumps just fine. then i try to restore that database on the postgres 7.3. since i get errors like ERROR: Invalid UNICODE character sequence found (0xe4636b) whenever a german or swedish special char occurs, i insert an \ecoding LATIN1 before the critical sections. then i can restore the complete database, with the difference that the special characters are garbage: ö and similar. How can i dump unicode databases to asci so that they are restored as unicode? i would like to edit the dump, as explained above. or How can i restore the database with its special chars in tact?
В списке pgsql-admin по дате отправления: