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?
Thanks, Tom
On 27 May 2003 at 17:47, Rory Campbell-Lange wrote:
> psql -d <dbname> [-U <user>] -c "<command>"
>
> eg (if you do not need to log in as a user):
> psql -d temporary -c "select * from people;"
>
> On 27/05/03, hodges@xprt.net (hodges@xprt.net) wrote:
> > Can anyone direct me to some example bash scripts that
> > execute queries thru psql?
> >
> > I need to check a bunch of tables for dates as a background
> > job daily. Seems like bash, perl, or python might be good
> > ways to do this. I think I know enough perl to do it but
> > maybe bash or python would be better choices?
>
> --
> Rory Campbell-Lange
> <rory@campbell-lange.net>
> <www.campbell-lange.net>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>