Re: Examples of accessing postgresql with scripts?

psql tom -c "SELECT * FROM firesides where age(date,now()) > '3 days'"


At 12:24 PM 5/31/03, hodges@xprt.net wrote:

>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
> >
>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 6: Have you searched our list archives?
>
>http://archives.postgresql.org