| From: | "K(dot) Ari Krupnikov" <ari(at)iln(dot)net> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | pipes in sql |
| Date: | 2001-03-01 03:33:42 |
| Message-ID: | 3A9DC316.353C5611@iln.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
In psql, i can pipe the results of a query to a shell script. How can I
do that from within a stored procedure?
I wrote a simple awk script to generate XML from a query result:
http://cvs.sourceforge.net/cgi-bin/cvsweb.cgi/utils/tbl2xml?rev=1.1.1.1&content-type=text/x-cvsweb-markup&cvsroot=dbdom
Use "\a" before running the script.
Is there a way to run this script before returning the query results to
a client (JDBC)?
--
K. Ari Krupnikov
DBDOM - bridging XML and relational databases
http://www.iter.co.il
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeff | 2001-03-01 03:43:54 | has anybody gotten cygwin1.1.8 to work with postgresql? |
| Previous Message | Doug McNaught | 2001-03-01 02:24:10 | Re: how to vacuum from cron? |