Re: Localization Oracle vs. Postgresql

From: Terry Yapt <yapt(at)technovell(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Localization Oracle vs. Postgresql
Date: 2003-08-29 15:49:11
Message-ID: 0qsukvc8tj63ik3r9enisd8qktvqki1i1t@4ax.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


>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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-08-29 16:03:42 Re: PostgreSQL upgrade -> fails to start server
Previous Message Joshua D. Drake 2003-08-29 15:26:04 Re: Errors sending Blob to DB