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?
pgpSjBmgLodVo.pgp
Description: PGP signature
