From: | SAKAIDA <sakaida(at)psn(dot)co(dot)jp> |
---|---|
To: | pgsql-interfaces(at)postgresql(dot)org |
Subject: | pgbash-2.0.1 released |
Date: | 2000-01-07 11:15:30 |
Message-ID: | 3875CAD2118.9319SAKAIDA@smtp.psn.ne.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)dbserv(dot)xxx(dot)co(dot)jp as db2 user sakaida;
> select * from test limit 100; | more ....with PIPELINE
> select * from test; > /tmp/sel.dat & ....with REDIRECTION
+BACKGROUND_JOB
> insert into test values(111,'name','address');
> connect to db3(at)dbserv3(dot)yyy(dot)co(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Sirish Kumar | 2000-01-07 12:20:18 | Create database problem |
Previous Message | Peter Mount | 2000-01-07 09:13:35 | RE: [INTERFACES] query java object? |