Re: Localization (for dates) Oracle vs. Postgresql

I want to change for example for one session the date-format from english to german, so that
The month names for example march will be März in German.
I only need that for the monthnames.
Is this possible to make that for example for one session.

-----Ursprüngliche Nachricht-----
Von: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Gesendet: Mittwoch, 3. September 2003 16:00
An: Amin Schoeib
Cc: pgsql-general(at)postgresql(dot)org
Betreff: Re: [GENERAL] Localization (for dates) Oracle vs. Postgresql

"Amin Schoeib" <aschoeib(at)4tek(dot)de> writes:
> Now I want to know if it is possible (when yes the how?) in Postgresql
> To set dynamically the Localization? For example in Oracle you can set
> the Localization for dates like this

What exactly do you want to localize?

The DATESTYLE setting and the various LC_xxx settings might help. We do not have the ability to change LC_COLLATE or LC_CTYPE on the fly, unfortunately.

regards, tom lane