Am Die, 2003-05-27 um 16.45 schrieb hodges(at)xprt(dot)net:
> 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?
psql mydb -c "SELECT * FROM mytable"
HTH
--
e-Trolley Sayegh & John, Nabil Sayegh
Tel.: 0700 etrolley /// 0700 38765539
Fax.: +49 69 8299381-8
PGP : www.e-trolley.de