Postgres Pro
Downloads
Home   >   mailing lists

Re: Converting an ASCII database to an UTF-8 database - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: Converting an ASCII database to an UTF-8 database
Date
Msg-id 200602172238.36654.peter_e@gmx.net
Whole thread Raw
In response to Converting an ASCII database to an UTF-8 database  (kishore.sainath@gmail.com)
Responses Re: Converting an ASCII database to an UTF-8 database  (Ragnar <gnari@hive.is>)
List pgsql-general
Tree view 
kishore.sainath@gmail.com wrote:
> How do I convert a database in the ASCII format into one of the UTF-8
> format?

ASCII is a subset of UTF-8, so you don't need to do anything.  Just
change the encoding entry in the pg_database table.  Of course, using
pg_dump would be the official way to convert a database between any two
encodings.

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

pgsql-general by date:

Previous
From: Robert Treat
Date:
Subject: Re: return setof and Temp tables
Next
From: Martijn van Oosterhout
Date:
Subject: Re: How do I use the backend APIs