From: | hodges(at)xprt(dot)net |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Examples of accessing postgresql with scripts? |
Date: | 2003-05-31 16:24:40 |
Message-ID: | 3ED874D8.25793.7F511F@localhost |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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(at)xprt(dot)net (hodges(at)xprt(dot)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(at)campbell-lange(dot)net>
> <www.campbell-lange.net>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-05-31 17:10:40 | Re: Examples of accessing postgresql with scripts? |
Previous Message | ghaverla | 2003-05-31 06:20:49 | Re: why doesn't an index help my simple query? |