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
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
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