environment variables, output format & setting current date

From: Brent Wood <baw(at)frc(dot)niwa(dot)cri(dot)nz>
To: pgsql-general(at)postgresql(dot)org
Subject: environment variables, output format & setting current date
Date: 2002-02-22 01:01:44
Message-ID: Pine.OSF.4.21.0202221349590.242868-100000@neptune.niwa.cri.nz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Three questions:

1. In a script, how do I set the value of a date attr to the current
date. I've tried a few obvious approaches but nothing works yet.

2.If I do:
psql <db> -c "select current_date;"
I get:

date
------------
2002-02-23
(1 row)

I can use:
psql <db> -c "select current_date;" | tail -3 | head -1
to just get the date value, but is there simpler way?

And lastly, I believe there are a few environmental variables used to
control various PostgreSQL behaviours, eg: date/time format. Where is
there a list of these? (I can't find them in the docs)

Thanks

=============================================================================

_-''-_ <Brent Wood> b(dot)wood(at)niwa(dot)cri(dot)nz Ph: +64(4)386-0300
'o \/ NIWA, Box 14901,
> ) /\ Kilbirnie, Wellington, New Zealand
`-===-' #include <std_disclaimer>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Command Prompt, Inc. 2002-02-22 01:03:45 Re: A Replication Idea
Previous Message Rich Shepard 2002-02-22 00:53:56 Re: data mining or statistical analysis with postgresql