Re: Localization (for dates) Oracle vs. Postgresql - Mailing list pgsql-general

From Amin Schoeib
Subject Re: Localization (for dates) Oracle vs. Postgresql
Date
Msg-id 70DD6153277512439CA4B66956A3098132D080@pdc.4tek-net.4tek.de
Whole thread Raw
In response to Localization (for dates) Oracle vs. Postgresql  ("Amin Schoeib" <aschoeib@4tek.de>)
Responses Re: Localization (for dates) Oracle vs. Postgresql  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: Trunc in Postgres
Next
From: Tom Lane
Date:
Subject: Re: Using oids