Date: Fri, 07 Jan 2000 20:15:30 +0900
From: SAKAIDA <sakaida@psn.co.jp>
To: pgsql-interfaces@postgresql.org
Subject: pgbash-2.0.1 released
Message-Id: <3875CAD2118.9319SAKAIDA@smtp.psn.ne.jp>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-2022-JP
Content-Transfer-Encoding: 7bit

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
 > insert into 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