How can I send some http request from postgresql function or trigger

Question

I need to send data via http protocol (GET or POST request) from the function or trigger. Is it possible?

Kevin · Answer 1 · 2010-07-24 14:42:04Z

up vote 4 down vote accepted

You could try writing the trigger in PL/Python and use urllib2 to POST.

answered Jul 24 '10 at 14:42

	Hmm, it looks like a PL/Perl in untrusted mode (postgresql.org/docs/8.4/interactive/plperl-trusted.html)... Are there differences in the use of PL/Python and PL/Perl? Both of then must be runned in untrusted mode and thats all? This means that I can use the module IO::Socket or HTTP::Request without any limitations? – im4LF Jul 24 '10 at 17:37
	Yes, that's all. – Frank Heikens Jul 24 '10 at 18:09

feedback

1 Answer