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@sss.pgh.pa.us]
Gesendet: Mittwoch, 3. September 2003 16:00
An: Amin Schoeib
Cc: pgsql-general@postgresql.org
Betreff: Re: [GENERAL] Localization (for dates) Oracle vs. Postgresql


"Amin Schoeib" <aschoeib@4tek.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_CTYPEon the fly, unfortunately. 

            regards, tom lane