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?

score 16 · Accepted Answer · answered Jul 24 '10 at 14:42

16

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

answered Jul 24 '10 at 14:42

Kevin

Hmm, it looks like a PL/Perl in untrusted mode (http://www.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

score 10 · Answer 2 · answered May 07 '12 at 22:18

10

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

answered May 07 '12 at 22:18

Sean

3

Is it trusted extention? – valijon May 23 '18 at 19:48
@valijon I know this is too late; but it seems like the author of it is a postgis core contributor. So, I guess it's trusted? – saedx1 Oct 13 '22 at 12:37

score 4 · Answer 3 · edited May 23 '17 at 12:08

4

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

edited May 23 '17 at 12:08

Community

answered Oct 01 '12 at 07:41

Craig Ringer

3 Answers3