From: SAKAIDA <sakaida@psn.co.jp>
To: hackers@postgreSQL.org
Cc: pgsql-interfaces@postgreSQL.org
Subject: pgbash-1.1.1 release
Date: Fri, 01 Oct 1999 17:24:57 +0900
Message-ID: <37F46FD92D0.D25FSAKAIDA@smtp.psn.ne.jp> (raw)
In-Reply-To: <199909300115.KAA01268@ext16.sra.co.jp>
References: <199909300115.KAA01268@ext16.sra.co.jp>
Hi,
With many cooperators, I have made a *bash built-in command* for
PostgreSQL called "pgbash".
The pgbash is the system which offers the 'direct SQL'/'embedded
SQL' interface for PostgreSQL by being included in the bash-2.x
shell.
Features of pgbash
-------------------
1.The pgbash has a function which is equivalent to psql except for
the interactive input processing function.
2.It is possible that pgbash carries out the interactive input
processing using the hysteresis editing function ( history, !,
fc command ) of bash.
3.An output of retrieval result and database information of pgbash
uses PSprint() which improved PQprint(). By PSprint(), it is
possible to output by plain table type, plain table + outer frame
type and HTML table type. And, it is possible to display NULL
value string(like '-NULL-') and bit zero string(like '-0-').
4.It is possible that pgbash manipulates multiple databases using
CONNECT, DISCONNECT and SET CONNECTION (or -d option ).
5.The pgbash has a function which substitutes the retrieval result
for the shell variable using FETCH INTO statement.
6.It is possible to set CGI mode. In CGI mode, the pgbash switches
the output to HTML, and read the datat by GET/POST method, and
read the data of HTTP_COOKIE.
7.The pgbash sets "error code", "error message", "number of tuples",
etc to the shell variable. Therefore, it is possible to know the
condition after the SQL execution.
Details is as follows.
http://www.psn.co.jp/PostgreSQL/pgbash/index-e.html
# I am very glad, if many people will use the pgbash.
--
Regards.
SAKAIDA Masaaki -- Osaka, Japan
# Sorry, I am not good at English.
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, hackers@postgreSQL.org
Subject: Re: pgbash-1.1.1 release
In-Reply-To: <37F46FD92D0.D25FSAKAIDA@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