Changing Character Sets - Mailing list pgsql-general

From Tim Gustafson
Subject Changing Character Sets
Date
Msg-id CAPyBAS7XtPez2kwvrcFeXypw_Lvy94ZJvtovMrdpfBPd91h=Lg@mail.gmail.com
Whole thread Raw
Responses Re: Changing Character Sets  (Magnus Hagander <magnus@hagander.net>)
Re: Changing Character Sets  (Andreas Kretschmer <akretschmer@spamfence.net>)
List pgsql-general
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.

--

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

pgsql-general by date:

Previous
From: "Gauthier, Dave"
Date:
Subject: Re: PG V9 on NFS
Next
From: Magnus Hagander
Date:
Subject: Re: Changing Character Sets