pgbash-2.0.1 released
От | SAKAIDA |
---|---|
Тема | pgbash-2.0.1 released |
Дата | |
Msg-id | 3875CAD2118.9319SAKAIDA@smtp.psn.ne.jp обсуждение исходный текст |
Список | pgsql-interfaces |
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
В списке pgsql-interfaces по дате отправления: