> 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