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

0 vote201 views1 answer
Intellij idea add mysql connector
SQL
0 vote191 views1 answer
Subquery aggregation
SQL
0 vote204 views1 answer
Select insert new table sql server
SQL
0 vote197 views1 answer
Sql server select ignore dupplicates
SQL
0 vote188 views1 answer
Hw to delete a procedure in pl sql
SQL
1 vote312 views1 answer
Mysql monthname
SQL
1 vote238 views1 answer
Key validation sql
SQL
0 vote227 views1 answer
Mysql where sum > 0
SQL
2 votes185 views2 answers
Spring import sql
SQL
1 vote224 views2 answers
Install sql server management studio ubuntu
SQL