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>
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 |