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

1 vote146 views1 answer
Load mysql dumb
SQL
1 vote135 views1 answer
Sql order by where condition
SQL
1 vote141 views2 answers
Begin transaction sql
SQL
1 vote137 views1 answer
Host 127.0 0.1 is not allowed to connect to this mysql server
SQL
1 vote129 views2 answers
String to date postgres
SQL
0 vote196 views1 answer
Placements hackerrank solution
SQL
2 votes134 views3 answers
Row number mysql
SQL
0 vote138 views1 answer
Mysql trim characters
SQL
1 vote118 views1 answer
Firebase bigquery cloud message
SQL
0 vote132 views1 answer
Change date format in oracle query
SQL