On Tue, Feb 12, 2013 at 5:34 PM, Tim Gustafson <t...@ucsc.edu> wrote: > Is there any way to change the character set of a database and its tables? > > I did a pg_dumpall to upgrade from Postgres 8.4 to Postgres 9.2, and > all the tables came back as UTF-8, and now Bacula is complaining that > it wants SQL_ASCII encoding for everything. I don't see a flag on > pg_dumpall or pg_restore to set which character encoding I'd like, and > Google has failed me.
What you're looking for is to change the encoding, right, and not the locale? 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. 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. -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
