Re: Localisation

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Martial Elise KIBA" <mkiba(at)delgi(dot)gov(dot)bf>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Localisation
Date: 2007-07-25 17:34:12
Message-ID: 28587.1185384852@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"Martial Elise KIBA" <mkiba(at)delgi(dot)gov(dot)bf> writes:
> I have a postgresql sever running on RedHat EL 4.0 Update 2.
> ...
> But postgresql steal respond in english, and TO_CHAR(date, 'Day, DD Month
> YYYY') return a date in english

What PG version is this? Are you sure it was built with --enable-nls?
("pg_config --configure" is the way to check.)

According to the manual, to_char() only emits localized month names if
you use "TMMonth". But I'm not sure why you're not seeing localized
messages, if the server was built with the correct options.

regards, tom lane

In response to

  • Localisation at 2007-07-25 17:28:44 from Martial Elise KIBA

Browse pgsql-admin by date

  From Date Subject
Next Message Eduardo Ferreira 2007-07-25 18:46:05 PL/SQL dynamic update error
Previous Message Martial Elise KIBA 2007-07-25 17:28:44 Localisation