Received: from bologna.nettuno.it (bologna.nettuno.it [193.43.2.1]) by hub.org (8.9.3/8.9.3) with ESMTP id JAA83346 for ; Thu, 10 Jun 1999 09:22:35 -0400 (EDT) (envelope-from jose@sferacarta.com) Received: from proxy.sferacarta.com (mail@sfcabop1.nettuno.it [193.207.10.213]) by bologna.nettuno.it (8.8.6/8.8.8/NETTuno 3.2) with ESMTP id PAA11600; Thu, 10 Jun 1999 15:22:10 +0200 (MDT) Received: from rosso.sferacarta.com (sferacarta.com) [10.20.30.5] by proxy.sferacarta.com with esmtp (Exim 2.05 #1 (Debian)) id 10s5d9-0005Hl-00; Thu, 10 Jun 1999 14:16:31 +0000 Message-ID: <375FABFC.24F4D505@sferacarta.com> Date: Thu, 10 Jun 1999 14:13:48 +0200 From: =?iso-8859-1?Q?Jos=E9?= Soares X-Mailer: Mozilla 4.5 [it] (Win95; I) X-Accept-Language: it MIME-Version: 1.0 To: Remigiusz Sokolowski CC: pgsql-sql@postgresql.org Subject: Re: [SQL] DataStyle References: Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Remigiusz Sokolowski ha scritto: > Hi! > I did something like that: > torell=> set DataStyle to 'ISO'; > > and get something like this: > NOTICE: Unrecognized variable datastyle > SET VARIABLE > > I try also with 'European' DataStyle - I remeber, that sometime ago this > command functions OK, and we've made no changes in configuration of > database. > hygea=> set DateStyle to 'ISO'; SET VARIABLE > > So my question is: > If there is a way to set DataStyle manually? > And if it is possible to set it default 'European' to all users? > As I saw it seems, that every user has its own settings of this. > TIA > Rem > You can do this job in three different ways: 1. Setting PGDATESTYLE environment variable for everey client as: export PGDATESTYLE='sql,european' # this format is: dd/mm/yyyy 2. Running postmaster using -oe parameter to set format date to 'European' convention. 3. Changing the following variables: bool EuroDates = true / false int DateStyle = USE_ISO_DATES USE_POSTGRES_DATES USE_ISO_DATES USE_SQL_DATES USE_GERMAN_DATES on ~/src/backend/utils/init/globals.c file before PostgreSQL installation). ______________________________________________________________ PostgreSQL 6.5.0 on i586-pc-linux-gnu, compiled by gcc 2.7.2.3 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ Jose'