Re: how to specify the locale that psql uses

Поиск
Список
Период
Сортировка
От Dhaval Jaiswal
Тема Re: how to specify the locale that psql uses
Дата
Msg-id 295335.28132.qm@web111206.mail.gq1.yahoo.com
обсуждение исходный текст
Ответ на how to specify the locale that psql uses  (Kent Tong <kent@cpttm.org.mo>)
Ответы Re: how to specify the locale that psql uses  (Shoaib Mir <shoaibmir@gmail.com>)
Список pgsql-general
 
 
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 по дате отправления:

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: log shipping from 64 bit linux server to a 32 bit linux server
Следующее
От: George Sakkis
Дата:
Сообщение: Enumerating a row set