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: | Raw Message | Whole Thread | 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? |