Re: Examples of accessing postgresql with scripts?

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
>