Thanks to <web Manager> and the PostgreSQL docs I have
found out what I was doing wrong. Actually the fix
was so dead simple that I am more than a little
embarrased to share.
But here goes...
The Debian package of PostgreSQL has a nifty
configuration file /etc/postgresql/postmaster.init .
Basically this file let's you customize just about any
PostgreSQL parameter that is configurable at run time
and worth fiddling with. I read the config file and
decided that setting:
Should do what I needed. Unfortunately what I
actually wanted was:
Thanks to web(at)inter-resa(dot)com, and special thanks to
the PostgreSQL team for their continued efforts.
--- Jason Earl <jdearl(at)yahoo(dot)com> wrote:
> With a little bit of grepping through the docs I
> found something that will mostly work for me. I
> simply need to have each client issue a:
> SET DATESTYLE TO 'Postgres';
> This works just fine, but (of course) I would rather
> have this set up as the 'default.' Does anyone know
> how to do this?
> Thanks again,
> --- Jason Earl <jdearl(at)yahoo(dot)com> wrote:
> > Note: I sent this to the pgsql-general list from
> > another account
> > yesterday, but it hasn't been answered. My
> > apologies
> > if you see it
> > twice. On the other hand, I have taken some time
> > proofread a bit,
> > so perhaps the punctuation won't be quite as bad.
> > I recently upgraded the PostgreSQL database on one
> > of
> > my Debian Linux
> > boxes to postgresql-7.0-0.beta3-1 in preparation
> > the grand
> > switchover to version 7.0. So far I am quite
> > impressed, but I have
> > had a little bit of a problem setting the
> > PGDATESTYLE
> > correctly. For
> > historical reasons I would like to continue using
> > the
> > US datestyle
> > (eg. Sat Jan 01 07:09:19 2000 MDT).
> > I have tried setting the variable in
> > /etc/postgresql/postmaster.init
> > and no joy. I have also tried to set the value of
> > PGDATESTYLE
> > manually in psql using:
> > processdata=>\set PGDATESTYLE US
> > When I do this I am able to then check the
> > that are set and
> > I get:
> > processdata=> \set
> > VERSION = 'PostgreSQL 7.0.0 on i686-pc-linux-gnu,
> > compiled by gcc 2.95.2'
> > DBNAME = 'processdata'
> > USER = 'earlj'
> > HOST = 'nampadata'
> > PORT = '5432'
> > ENCODING = 'SQL_ASCII'
> > PROMPT1 = '%/%R%# '
> > PROMPT2 = '%/%R%# '
> > PROMPT3 = '>> '
> > HISTSIZE = '500'
> > PGDATESTYLE = 'US'
> > Unfortunately, when I test it out:
> > processdata=> select 'now'::datetime;
> > ?column?
> > ------------------------
> > 2000-04-19 14:09:06-06
> > (1 row)
> > I still get the ISO format. So what do I need to
> > to get my US
> > datestyle back?
> > Sorry to bother,
> > Jason Earl
> > __________________________________________________
> > Do You Yahoo!?
> > Send online invitations with Yahoo! Invites.
> > http://invites.yahoo.com
> Do You Yahoo!?
> Send online invitations with Yahoo! Invites.
Do You Yahoo!?
Send online invitations with Yahoo! Invites.
pgsql-sql by date
|Next:||From: Tom Lane||Date: 2000-04-20 18:14:27|
|Subject: Re: US Date Style |
|Previous:||From: Jason Earl||Date: 2000-04-20 16:42:59|
|Subject: Re: US Date Style|
pgsql-general by date
|Next:||From: Jeff MacDonald||Date: 2000-04-20 18:48:39|
|Subject: Re: [GENERAL] PostgreSQL hats, shirts, keychains, mugs|
|Previous:||From: Steve Wolfe||Date: 2000-04-20 16:51:15|
|Subject: One last thing... psql and readline|