Re: [INTERFACES] pgbash-1.1.1 release - Mailing list pgsql-interfaces

From Clark C. Evans
Subject Re: [INTERFACES] pgbash-1.1.1 release
Date
Msg-id Pine.LNX.4.10.9910142148240.10760-100000@distributedsystems.com
Whole thread Raw
In response to pgbash-1.1.1 release  (SAKAIDA <sakaida@psn.co.jp>)
List pgsql-interfaces
This works like a charm.  Thanks tons!

;) Clark

On Fri, 1 Oct 1999, SAKAIDA wrote:

> 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$B!!(B
> # Sorry, I am not good at English. 
> 
> 
> ************
> 



pgsql-interfaces by date:

Previous
From: "Patrick Welche"
Date:
Subject: Re: [INTERFACES] ODBC / M$Access error
Next
From: "Ibrahim Shaame"
Date:
Subject: ecpg - example code