| 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: | Whole Thread | Raw Message | 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 |