Re: environment variables, output format & setting current

It looks that you want the date, for usage at the shell level. Why not just do "date +%Y-%m-%d" ?

cheers,
thalis



On Fri, 22 Feb 2002, Brent Wood wrote:

>
> 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.wood@niwa.cri.nz  Ph: +64(4)386-0300
>       'o     \/  NIWA, Box 14901,
>       > )    /\  Kilbirnie, Wellington, New Zealand
>       `-===-'    #include <std_disclaimer>
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>