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
ispossible 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
possibleto 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.