Re: Per-database/schema settings
Roland Roberts <roberts@panix.com>
From: Roland Roberts <roberts@panix.com>
To: Hackers List <pgsql-hackers@postgresql.org>
Date: 2000-07-05T19:31:22Z
Lists: pgsql-hackers
>>>>> "eisentrp" == eisentrp <eisentrp@csis.gvsu.edu> writes:
eisentrp> About datestyle, I had thought that this setting should
eisentrp> really be deprecated, with the arrival of the 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