Re: Examples of accessing postgresql with scripts? - Mailing list pgsql-novice

hodges@xprt.net writes:
> This works for me:
> a=`eval date`  # now $a is current date/time
> psql tom -c "SELECT * FROM firesides where date > '$a'"

> Now how to set $a to 3 days in the future?

I dunno how you would do that on the shell-script side, but it's easy to
do the date arithmetic on the SQL side instead:

psql tom -c "SELECT * FROM firesides where date > (current_date + 3)"

            regards, tom lane