How to query pgsql from a BASH script ?

Hello *,

I am puzzeling around, how to query a postgresql from a BASH script.
Generaly it must do nothing else as

1) Get VALUEs from a DB/TABLE
e.g.
program --db pgsql.sld.tld --search "$COLNAME,$VAL" \
--get "COL1,COL3,COL4,..."

2) Write one or more new VALUEs in the DB/TABLE
e.g.
program --db pgsql.sld.tld --search "$COLNAME,$VAL" \
--set "COL1:VAL1,COL3:VAL3,..."

3) Remove ROWS from the DB/TABLE
e.g.
program --db pgsql.sld.tld --search "$COLNAME,$VAL" --remove

Curently I have only a sulution with a text/plain file but
there is a problem with locking and the file is already
180 kByte, which mean grep/cut/sed are to slow for it.

Under "heavy" load I need to access the database around
1-3 times (maybe in the future more) per second.

Any suggestions ?

Greetings
Michelle

--
Linux-User #280138 with the Linux Counter, http://counter.li.org/
Michelle Konzack Apt. 917 ICQ #328449886
50, rue de Soultz MSM LinuxMichi
0033/3/88452356 67100 Strasbourg/France IRC #Debian (irc.icq.com)