latin1 -> unicode

Am Donnerstag, 22. Mai 2003 11:15 schrieb Jules Chalier:

hy

I would like to convert my latin1 database (allready create with data
inside....) in a unicode database.

It should work like this:

* Dump the Database (pg_dump)

* Put "\encoding latin1" into the dump. (Not sure where, probably once
at the beginning or maybe after each "\connect"). This makes the restore
process considering following data as latin1. The database will take care of
converting it into the native unicode.

* Create the new Database with Unicode encoding (createdb -E unicode)

* Read the dump with psql into the new database.

Mit freundlichem Gruß / With kind regards
Holger Klawitter
--
lists@klawitter.de

Holger Klawitter wrote:

Am Donnerstag, 22. Mai 2003 11:15 schrieb Jules Chalier:

hy

I would like to convert my latin1 database (allready create with data
inside....) in a unicode database.

It should work like this:

* Dump the Database (pg_dump)

* Put "\encoding latin1" into the dump. (Not sure where, probably once
at the beginning or maybe after each "\connect").

After each \connect

How do you set encoding in pgadmin

-----Original Message-----
From: Joseph Shraibman [mailto:jks@selectacast.net]
Sent: Monday, May 26, 2003 2:36 PM
To: Holger Klawitter
Cc: Jules Chalier; pgsql-general@postgresql.org
Subject: Re: [GENERAL] latin1 -> unicode

Holger Klawitter wrote:

Am Donnerstag, 22. Mai 2003 11:15 schrieb Jules Chalier:

hy

I would like to convert my latin1 database (allready create with data
inside....) in a unicode database.

It should work like this:

* Dump the Database (pg_dump)

* Put "\encoding latin1" into the dump. (Not sure where, probably once
at the beginning or maybe after each "\connect").

After each \connect

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster