Thread: 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.
On Thursday 22 January 2009 09:36:53 Kent Tong wrote: > 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-tp21599904p2 >1599904.html Sent from the PostgreSQL - general mailing list archive at > Nabble.com. psql --help ? -- Fahrbahn ist ein graues Band weisse Streifen, grüner Rand
Reg Me Please wrote: > > psql --help ? > which option you're referring to? I tried --locale but it had no effect. ----- -- 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-tp21599904p21600296.html Sent from the PostgreSQL - general mailing list archive at Nabble.com.
On Thursday 22 January 2009 10:04:58 Kent Tong wrote: > Reg Me Please wrote: > > psql --help ? > > which option you're referring to? I tried --locale but it had no effect. > > > ----- > -- > 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-tp21599904p2 >1600296.html Sent from the PostgreSQL - general mailing list archive at > Nabble.com. Weel, you have two locales: one on the client and one the server. The former is needed for "translations" to the server whenver the two don't match. The latter is chosen at the CREATE DATABASE <dbname> ENCODING <encoding>. -- Fahrbahn ist ein graues Band weisse Streifen, grüner Rand
Reg Me Please wrote: > > Weel, you have two locales: one on the client and one the server. > The former is needed for "translations" to the server whenver the two > don't > match. > The latter is chosen at the CREATE DATABASE <dbname> ENCODING <encoding>. > I am referring to the locale on the client that determines the text prompts it outputs. ----- -- 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-tp21599904p21601001.html Sent from the PostgreSQL - general mailing list archive at Nabble.com.
On Thursday 22 January 2009 10:51:41 Kent Tong wrote: > Reg Me Please wrote: > > Weel, you have two locales: one on the client and one the server. > > The former is needed for "translations" to the server whenver the two > > don't > > match. > > The latter is chosen at the CREATE DATABASE <dbname> ENCODING <encoding>. > > I am referring to the locale on the client that determines the text prompts > it > outputs. > > ----- > -- > 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-tp21599904p2 >1601001.html Sent from the PostgreSQL - general mailing list archive at > Nabble.com. In general, refer to "8.13.2. Encoding Handling" and "Chapter 22. Localization" on v8.3.5 documentation. Then you could use either the "\encoding" or the "SET client_encoding TO ..." into psql, the "PGCLIENTENCODING" environment variable or the "client_encoding" main configuration argument. Moreover you can check from psql and pl/pgsql the current client encoding with SELECT * FROM pg_client_encoding(); I hope any of these will help. -- Fahrbahn ist ein graues Band weisse Streifen, grüner Rand
Reg Me Please wrote: > > In general, refer to "8.13.2. Encoding Handling" and "Chapter 22. > Localization" on v8.3.5 documentation. > Thanks for your replies. However, as I said before, I am asking for the locale controlling the text prompts printed by psql. I've read the chapter you quoted before posting for help and it didn't apply to the issue. ----- -- 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-tp21599904p21605547.html Sent from the PostgreSQL - general mailing list archive at Nabble.com.
Kent Tong wrote: > I am referring to the locale on the client that determines the text prompts it outputs. I think "Reg me Please" got you wrong, here's the answer: To set the locale for server messages, set the server configuration parameter "lc_messages" to the appropriate value. You can either do this for the current session with the SQL command: SET lc_messages='....'; or you can change the default in postgresql.conf and reload. To change the locale of messages *by* psql, libpq and other client programs, change the current locale where you start the client. How you do this depends on the operating system; on UNIX you do it by setting the LANG environment variable. Yours, Laurenz Albe
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 ] ]
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
On Fri, Mar 27, 2009 at 9:35 AM, Dhaval Jaiswal <bablu_postgres@yahoo.com> wrote:
Please updates yourself with the latest version as its 8.3.7 these days and you are still like years and years behind with version 7.2 documentation :)
I dont think so the person asking the question ever asked for changing encoding for the database. Please make sure to read the question atleast, as it was about changing locale for psql.
In order to do that
For server messages:
-------------------------------
set the configuration parameter "lc_messages" to a value you like to have for getting messages back from server.
It can done in both ways, for the session and permanently.
In order to do for a session use:
set lc_message = ....
and otherwise set it in your postgresql.conf file and reload.
For Client messages:
-----------------------------
For client programs like psql, change the current locale where you are starting up psql. I am not sure about windows but in Linux you can do this by setting LANG environment variable.
--
Shoaib Mir
http://shoaibmir.wordpress.com/
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.
Please updates yourself with the latest version as its 8.3.7 these days and you are still like years and years behind with version 7.2 documentation :)
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.
I dont think so the person asking the question ever asked for changing encoding for the database. Please make sure to read the question atleast, as it was about changing locale for psql.
In order to do that
For server messages:
-------------------------------
set the configuration parameter "lc_messages" to a value you like to have for getting messages back from server.
It can done in both ways, for the session and permanently.
In order to do for a session use:
set lc_message = ....
and otherwise set it in your postgresql.conf file and reload.
For Client messages:
-----------------------------
For client programs like psql, change the current locale where you are starting up psql. I am not sure about windows but in Linux you can do this by setting LANG environment variable.
Shoaib Mir
http://shoaibmir.wordpress.com/
I had given reply abt windows
From: Shoaib Mir <shoaibmir@gmail.com>
To: Dhaval Jaiswal <bablu_postgres@yahoo.com>
Cc: Kent Tong <kent@cpttm.org.mo>; pgsql-general@postgresql.org
Sent: Friday, March 27, 2009 4:47:43 AM
Subject: Re: [GENERAL] how to specify the locale that psql uses
On Fri, Mar 27, 2009 at 9:35 AM, Dhaval Jaiswal <bablu_postgres@yahoo.com> wrote:
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
Please updates yourself with the latest version as its 8.3.7 these days and you are still like years and years behind with version 7.2 documentation :)
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.
I dont think so the person asking the question ever asked for changing encoding for the database. Please make sure to read the question atleast, as it was about changing locale for psql.
In order to do that
For server messages:
-------------------------------
set the configuration parameter "lc_messages" to a value you like to have for getting messages back from server.
It can done in both ways, for the session and permanently.
In order to do for a session use:
set lc_message = ....
and otherwise set it in your postgresql.conf file and reload.
For Client messages:
-----------------------------
For client programs like psql, change the current locale where you are starting up psql. I am not sure about windows but in Linux you can do this by setting LANG environment variable.
Shoaib Mir
http://shoaibmir.wordpress.com/