Postgres Pro
Downloads
Home   >   mailing lists

Re: Per-database/schema settings - Mailing list pgsql-hackers

From Roland Roberts
Subject Re: Per-database/schema settings
Date
Msg-id m2sntojrw5.fsf@tycho.rlent.pnet
Whole thread Raw
In response to Re: Per-database/schema settings  (eisentrp@csis.gvsu.edu)
List pgsql-hackers
Tree view 
>>>>> "eisentrp" == eisentrp  <eisentrp@csis.gvsu.edu> writes:
   eisentrp> About datestyle, I had thought that this setting should   eisentrp> really be deprecated, with the arrival
ofthe to_char()   eisentrp> family. If you like a default datestyle, then you can   eisentrp> define a view based on
to_char().

As far as datestyle goes, I like Oracle's
   alter session set nls_date_format='MON DD, YYYY HH24:MI:SS';

This doesn't really deal with default for a database, but I've longed
fr this in Postgres....

roland
--            PGP Key ID: 66 BC 3B CD
Roland B. Roberts, PhD                    Unix Software Solutions
roberts@panix.com                      76-15 113th Street, Apt 3B
rbroberts@acm.org                          Forest Hills, NY 11375

pgsql-hackers by date:

Previous
From: Denis Perchine
Date:
Subject: Re[2]: Re: pg_dump and LOs (another proposal)
Next
From: JanWieck@t-online.de (Jan Wieck)
Date:
Subject: 2nd update on TOAST