Re: Database Encoding

Hi,

psql -l gives you your database listing with encoding

bash-2.05b$ psql -l
               List of databases
          Name           |  Owner   | Encoding
-------------------------+----------+----------
 1sthoney                | postgres | LATIN1
 ami_bulletin            | postgres | LATIN1
 amiedu_www              | postgres | LATIN1
 amiedu_www_eng          | postgres | LATIN1
...

The default, template1, is set with initdb command. e.g. 

initdb -E LATIN1 ..., so one way to change it is to re-init.

You can create databases with different encoding (from template1) with same 
switch e.g. 

reatedb mydb -E UTF8 ...

Cheers,

Aarni

On Saturday 16 April 2005 14:22, you wrote:
> i would like to make sure my template1 is encoded as
> latin1.
>
> 1. how can i check the db encoding?  either a psql or
> pgadmin method is fine.
>
> 2. how can i change it?
>
> 3. how can i change it in an existing database with
> lots of tables (i can remove all data, if required).
>
> i just went with the default when i set up the cygwin
> version of pgsql - i'm not even sure what it is.
>
> tia...
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam?  Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org


--------------
This is a bugfree broadcast to you
from **Kmail**
on **Fedora Core 2** linux system
--------------