From: | Tim Greenwood <timothy(at)greenwood(dot)name> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Checking my understanding of locales |
Date: | 2009-08-06 18:26:10 |
Message-ID: | 7822ca810908061126t11af009eo5494c030585cb2c@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
From experimentation and reading the documentation I understand that locale
settings governing the formatting of numbers and dates are only set at the
server and not the client.
For example - the database is initialized in the fr_FR locale. Starting
psql under the en_US locale and executing "select
to_char(1234.56,'9G999D99')" gives an output of 1 234,56 - i.e. the
formatting of the server, not the client.
lking about
I do see some English messages from psql (but also French for anything from
the server).
Can a single database support clients running in different locales from it
for formatting (not talking about ORDER BY here) and if so, how?
Tim
From | Date | Subject | |
---|---|---|---|
Next Message | Simon GEORGES | 2009-08-07 11:39:49 | Stange behavior of sort request |
Previous Message | Michael Wood | 2009-08-06 12:35:56 | Re: Assistance with importing a csv into a PostgreSQL database |