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(at)postgresql(dot)org

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