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
--------------