Thread: pipes in sql

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