pgbash-2.0.1 released

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

Browse pgsql-interfaces by date

  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?