From: SAKAIDA <sakaida@psn.co.jp>
To: pgsql-interfaces@postgresql.org
Subject: pgbash-2.0.1 released
Date: Fri, 07 Jan 2000 20:15:30 +0900
Message-ID: <3875CAD2118.9319SAKAIDA@smtp.psn.ne.jp> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: sakaida@psn.co.jp
Subject: Re: pgbash-2.0.1 released
In-Reply-To: <3875CAD2118.9319SAKAIDA@smtp.psn.ne.jp>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox