Call rest api from postgresql

CREATE OR REPLACE FUNCTION restful.put(auri character varying, ajson_text text)
 RETURNS text
 LANGUAGE plperlu
 SECURITY DEFINER
AS $function$
  use REST::Client;  
  use Encode qw(encode);
  my $client = REST::Client->new();    
  $client->getUseragent()->proxy( 'https', 'http://some-proxy/' ); # use for proxy authentication
  $client->addHeader('Content-Type', 'application/json');          # headers
  $client->POST( $_[0], encode('UTF-8', $_[1]));                   # encoding
  return $client->responseContent();  
$function$

Source: stackoverflow.com

Similar codes

4 votes172 views3 answers
Mysql varchar length
SQL
0 vote190 views1 answer
Mysql max number not returning correct value
SQL
1 vote189 views1 answer
Mysql pretty date format
SQL
0 vote200 views1 answer
Sql query to find duplicate email address
SQL
0 vote205 views1 answer
Drop specific row postgresql
SQL
0 vote183 views1 answer
Compare subqueries oracle
SQL
0 vote181 views1 answer
Oracle call a function in a insert statement
SQL
21 votes192 views3 answers
Search for column name in sql db when i don't know which table it is in
SQL
1 vote193 views1 answer
Postgresql contains
SQL
5 votes180 views1 answer
Minecraft java port number
SQL