Re: environment variables, output format & setting current

Try:

psql <db> -A -t -c "select current_date;"


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