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 по дате отправления:

Предыдущее
От: Peter Mount
Дата:
Сообщение: RE: [INTERFACES] query java object?
Следующее
От: "Sirish Kumar"
Дата:
Сообщение: Create database problem