Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group