pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: José Soares <jose@sferacarta.com>
To: Remigiusz Sokolowski <rems@gdansk.sprint.pl>
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] DataStyle
Date: Thu, 10 Jun 1999 14:13:48 +0200
Message-ID: <375FABFC.24F4D505@sferacarta.com> (raw)
References: <Pine.GS4.4.02A.9906101152430.8884-100000@netra.gdansk.sprint.pl>


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'





view thread (3+ messages)  latest in thread

Message-ID: <375FABFC.24F4D505@sferacarta.com>
Permalink:  ../375FABFC.24F4D505@sferacarta.com/
Also on:    postgresql.org/message-id/375FABFC.24F4D505@sferacarta.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-sql@postgresql.org
  Cc: jose@sferacarta.com, rems@gdansk.sprint.pl
  Subject: Re: [SQL] DataStyle
  In-Reply-To: <375FABFC.24F4D505@sferacarta.com>
  References: <Pine.GS4.4.02A.9906101152430.8884-100000@netra.gdansk.sprint.pl> <375FABFC.24F4D505@sferacarta.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox