pgbash-1.1.1 release

From: SAKAIDA <sakaida(at)psn(dot)co(dot)jp>
To: hackers(at)postgreSQL(dot)org
Cc: pgsql-interfaces(at)postgreSQL(dot)org
Subject: pgbash-1.1.1 release
Date: 1999-10-01 08:24:57
Message-ID: 37F46FD92D0.D25FSAKAIDA@smtp.psn.ne.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-interfaces

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.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Oleg Bartunov 1999-10-01 11:38:11 Re: [HACKERS] pgbash-1.1.1 release
Previous Message Zakkr 1999-10-01 07:43:14 Re: [HACKERS] Re: TO_CHAR()

Browse pgsql-interfaces by date

  From Date Subject
Next Message zhang-lan 1999-10-01 09:56:04 Program accessing database via servlet
Previous Message Magnus Hagander 1999-10-01 07:58:35 RE: [INTERFACES] SSL and ODBC