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.
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() |
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 |