Postgres Pro
Downloads
Home   >   mailing lists

Re: how to specify the locale that psql uses - Mailing list pgsql-general

From Dhaval Jaiswal
Subject Re: how to specify the locale that psql uses
Date
Msg-id 295335.28132.qm@web111206.mail.gq1.yahoo.com
Whole thread Raw
In response to how to specify the locale that psql uses  (Kent Tong <kent@cpttm.org.mo>)
Responses Re: how to specify the locale that psql uses  (Shoaib Mir <shoaibmir@gmail.com>)
List pgsql-general
Tree view
 
 
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.
 
 
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
 
 
 
 
 
 
 
 
 
 

From: Kent Tong <kent@cpttm.org.mo>
To: pgsql-general@postgresql.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.


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: log shipping from 64 bit linux server to a 32 bit linux server
Next
From: George Sakkis
Date:
Subject: Enumerating a row set