Date: Fri, 01 Oct 1999 17:24:57 +0900
From: SAKAIDA <sakaida@psn.co.jp>
To: hackers@postgreSQL.org
Cc: pgsql-interfaces@postgreSQL.org
Subject: pgbash-1.1.1 release
In-Reply-To: <199909300115.KAA01268@ext16.sra.co.jp>
References: <199909300115.KAA01268@ext16.sra.co.jp>
Message-Id: <37F46FD92D0.D25FSAKAIDA@smtp.psn.ne.jp>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-2022-JP
Content-Transfer-Encoding: 7bit

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.