Re: Changing Character Sets

> What you're looking for is to change the encoding, right, and not the locale?

Correct.

> You can't change the encoding of a database, but you can use a
> different one when you create it - this can be specified in the CREATE
> DATABASE statement.

That's what I wound up doing.

> You can also ask pg_dump to use a specific encoding using the -E
> parameter. You can't do it on pg_dumpall, but you can do it if you use
> pg_dump.

That's good to know.

I'm curious why a pg_dumpall from 8.4 followed by a restore in 9.2
caused the character sets to change at all.  Was there some change in
the default character sets between 8.4 and 9.2?

--

Tim Gustafson
tjg@ucsc.edu
831-459-5354
Baskin Engineering, Room 313A