Re: how to specify the locale that psql uses

When you install postgreSQL over XP at the same time it asks for encoding & locale.
Set at the same time. Follow the below link will give you more idea.

http://www.postgresql.org/docs/7.2/static/multibyte.html

If you want to change the locale of existing database. You can't..
The workaround for that you can create another cluster with initdb command with supported locale.

If you want to create database with different encoding. You can.
You can execute the following command.

Command:     CREATE DATABASE
Description: create a new database
Syntax:
CREATE DATABASE name
    [ [ WITH ] [ OWNER [=] dbowner ]
           [ TEMPLATE [=] template ]
           [ ENCODING [=] encoding ]
           [ TABLESPACE [=] tablespace ]
           [ CONNECTION LIMIT [=] connlimit ] ]

--
Thanks & Regards,
Dhaval Jaiswal
EnterpriseDB
www.enterprisedb.com

________________________________
From: Kent Tong <kent(at)cpttm(dot)org(dot)mo>
To: pgsql-general(at)postgresql(dot)org
Sent: Thursday, January 22, 2009 2:06:53 PM
Subject: [GENERAL] how to specify the locale that psql uses

Hi,

I am running a Chinese edition of XP. When I start psql, it is probably
trying to display Chinese and
maybe it gets the encoding wrong, it displays garbage in its console. Is
there any way to tell it to
just use English instead? In Linux, one can do something like "LC_ALL=en
psql" but it doesn't seem
to work on the Windows port of PostgreSQL.

Thanks for any help!

-----
--
Kent Tong
Wicket tutorials freely available at http://www.agileskills2.org/EWDW
Axis2 tutorials freely available at http://www.agileskills2.org/DWSAA
--
View this message in context: http://www.nabble.com/how-to-specify-the-locale-that-psql-uses-tp21599904p21599904.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.