Postgres Pro
Downloads
Home   >   mailing lists

Re: HowTo change encoding type.... - Mailing list pgsql-sql

From Peter Eisentraut
Subject Re: HowTo change encoding type....
Date
Msg-id 200411260830.41161.peter_e@gmx.net
Whole thread Raw
In response to HowTo change encoding type....  (Andrew M <andrew@jibeya.com>)
List pgsql-sql
Tree view 
Andrew M wrote:
> how do I change the encoding type in postgreSQL (8) from UTF-8 to
> ISO-8859-1?

Dump your database, drop your database, recreate your database with the 
different encoding, reload your data.  Make sure the client encoding is 
set correctly during all this.

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/

pgsql-sql by date:

Previous
From: Jaime Casanova
Date:
Subject: select with a function
Next
From: "Andrew Thorley"
Date:
Subject: tutorials for complex.sql & complex.c