I cannot find any information about wether PostgreSQL has EXTPROC or not. Can
someone tell me if it dose or if there is a better way to do this.
I need to be able to run a program when some data is requested from the
database. Some query will do a SELECT on a known table and I need to have
some event trigger that makes a call to generate a small XML file and then
post it to a web server, get a reply back and then update a local table with
the information it received.
I have looked at how to do this in Oracle but I want to use PostgreSQL.
For Oracle I found this, http://www.orafaq.com/faqplsql.htm#OSCOMMAND. In
Oracle I need to make an EXTPROC call a bash script that will run wget and
then the bash script will make a new connection to the database to send it
the result data. The EXTPROC will not require any returned information. It
just needs to start the action.
Is there any way this can be done in PostgreSQL? Is there some other way to do
this?