Re: How to query pgsql from a BASH script ?

> So if I understand it right, if I have a table like
>
> Table:  ip_table
>        ip       |   ctime    |   atime
> ----------------+------------+------------
> aaa.bbb.ccc.ddd | 1234567890 | 2345678901
> eee.fff.ggg.hhh | 3456789012 | 4567890123
>
> and I need only
>
>     CONNECT TO localhost USER michelle.konzack;
>     RETVAL=`SELECT ctime, atime FROM ip_table WHERE ip = $SEARCH;`
>
test=# select * from foo;
 a  | b
----+----
 10 | 10
 10 | 20

pgbash> retval=`select a,b from foo;`
pgbash> echo $retval
a | b ----+---- 10 | 10 10 | 20 (2 rows)

I remeber other project

http://www.edlsystems.com/shellsql

bye

Pavel Stehule