Thread: Localization Oracle vs. Postgresql

Hi,
I am a Postgres newbie who worked until now with Oracle.
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
Alter session set NLS_DATE_LANGUAGE=American NLS_TERRITORY=America

This example would set the Date-Localization to American but only for the actual session.

Is something like this possible in Postgresql???

Thanxx

Schoeib Amin

4Tek Gesellschaft für angewandte Informationstechnologien mbH
Schoeib Amin
Tel.  +49 (0) 69 697688-132
Fax. +49 (0) 69 697688-111
http://www.4tek.de

>For example in Oracle you can set the  Localization for dates like this
>Alter session set NLS_DATE_LANGUAGE=American NLS_TERRITORY=America

SET DATESTYLE TO NonEuropean;

>This example would set the Date-Localization to American but only for the actual session.

This one too I think so.

>Is something like this possible in Postgresql???

Look at:
 http://www.postgresql.org/docs/7.3/static/sql-set.html

Greetings

>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
>Alter session set NLS_DATE_LANGUAGE=American NLS_TERRITORY=America

SET DATESTYLE TO NonEuropean;

>
>This example would set the Date-Localization to American but only for the actual session.

This one too.

>Is something like this possible in Postgresql???

Look at:
 http://www.postgresql.org/docs/7.3/static/sql-set.html

Greetings