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

-2 votes192 views1 answer
Remove root password mysql
SQL
3 votes197 views1 answer
Oracle limit user tablespace
SQL
0 vote146 views1 answer
Oracle function select into
SQL
1 vote308 views1 answer
Mysql breakline on string
SQL
0 vote175 views2 answers
Mysql password error create datbase
SQL
0 vote222 views1 answer
Arithmetic expression in sql
SQL
0 vote238 views1 answer
Capabilities of sql select statements
SQL
15 votes173 views2 answers
Install mysql 8 ubuntu 18.04
SQL
0 vote190 views1 answer
Reona
SQL
0 vote210 views1 answer
Sql where time stamp is in between
SQL