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 votes312 views2 answers
Postgresql reset sequence
SQL
1 vote343 views1 answer
Set id count mysql
SQL
0 vote345 views1 answer
How to run mysql on terminal mac
SQL
0 vote341 views1 answer
Firebase sql
SQL
0 vote314 views1 answer
Postgresql not in alternative
SQL
-1 vote344 views1 answer
Pl sql drop trigger
SQL
0 vote335 views1 answer
Inserting values with beekeeper get error null value in column createdAt violates not-null constraint
SQL
0 vote326 views1 answer
Postgres select from values
SQL
0 vote314 views1 answer
Addition of 2 column value in mysql
SQL
0 vote363 views1 answer
How to convert external table to managed table in hive
SQL