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>