Hi,
I have released the pgbash-2.0.1.
http://www.psn.co.jp/PostgreSQL/pgbash/index-e.html
Pgbash-2.0.1 is the SHELL which included the direct SQL/embedded
SQL interface for PostgreSQL by the improvement on the bash-2.03
shell. Pgbash can execute SQL statement as a shell command. And it
is possible to execute the SQL statement with PIPELINE/REDIRECTION/
BACKGROUNF_JOB options. Pgbash can be used as a Log-in shell(or
Sub-shell).
ex.)> connect to db2@dbserv.xxx.co.jp as db2 user sakaida; > select * from test limit 100; | more ....with PIPELINE>
select* from test; > /tmp/sel.dat & ....with REDIRECTION +BACKGROUND_JOB>
insertinto test values(111,'name','address'); > connect to db3@dbserv3.yyy.co.jp as db3 user postgres;> exec_sql -d db2
"select* from test" > exec_sql -d db3 "select * from test3"....execute SQL with OPTION> ls
> begin;> declare cur cursor for select * from test;> fetch in cur into :AA,:BB; ....into SHELL
VARIABLEs>echo "AA=$AA, BB=$BB" > end;> fc fetch ....edit history and go> !echo
> disconnect all
Regards,
SAKAIDA Masaaki -- Osaka, Japan