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 vote318 views1 answer
Cannot insert duplicate key in object 'dbo.Instructor'. The duplicate key value is (2).
SQL
1 vote357 views1 answer
Mysql select row max date
SQL
0 vote340 views1 answer
Mysql wait_timeout
SQL
3 votes325 views2 answers
Truncate all tables
SQL
0 vote332 views1 answer
Install mysql for fedora 34
SQL
2 votes316 views3 answers
Postgres remove foreign key constraint
SQL
7 votes337 views1 answer
Return insert results in POSTGRESQL
SQL
0 vote442 views1 answer
Php insert null mysql
SQL
1 vote354 views2 answers
Grab part of a string sql
SQL
1 vote330 views1 answer
How to unlock table in mysql
SQL