Re: Examples of accessing postgresql with scripts?
От | hodges@xprt.net |
---|---|
Тема | Re: Examples of accessing postgresql with scripts? |
Дата | |
Msg-id | 3ED874D8.25793.7F511F@localhost обсуждение исходный текст |
Ответ на | Re: Examples of accessing postgresql with scripts? (Rory Campbell-Lange <rory@campbell-lange.net>) |
Ответы |
Re: Examples of accessing postgresql with scripts?
Re: Examples of accessing postgresql with scripts? |
Список | 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@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 >
В списке pgsql-novice по дате отправления: