psql <db> -A -t -c "select current_date;" will do what
you appear to want.
But, as already pointed out, you are probably better
off using the methods provided in your scripting
language (shell or whatever).
--- Brent Wood <baw@frc.niwa.cri.nz> 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
__________________________________________________
Do You Yahoo!?
Yahoo! Sports - Coverage of the 2002 Olympic Games
http://sports.yahoo.com
