pipes in sql
Started by K. Ari Krupnikovabout 25 years ago1 messagesgeneral
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