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 · Accepted Answer · 2010-07-24 14:42:04Z

up vote 6 down vote accepted

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

answered Jul 24 '10 at 14:42

Kevin
604416

	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

Craig Ringer · Answer 2 · 2012-10-01 07:41:10Z

up vote 0 down vote

Any "untrusted" language with HTTP support can do this:

answered Oct 1 '12 at 7:41

Craig Ringer
17.2k21645

feedback

Sean · Answer 3 · 2012-05-07 22:18:21Z

up vote 1 down vote

There is an extension to do this, use with caution.

answered May 7 '12 at 22:18

Sean
1413

feedback

3 Answers