Re: [INTERFACES] pgbash-1.1.1 release
От | Clark C. Evans |
---|---|
Тема | Re: [INTERFACES] pgbash-1.1.1 release |
Дата | |
Msg-id | Pine.LNX.4.10.9910142148240.10760-100000@distributedsystems.com обсуждение исходный текст |
Ответ на | pgbash-1.1.1 release (SAKAIDA <sakaida@psn.co.jp>) |
Список | 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 по дате отправления: