Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group