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 vote169 views1 answer
Test the postgresql db connection
SQL
3 votes152 views1 answer
Difference sql vs mysql
SQL
2 votes174 views2 answers
Change mysql password from command line
SQL
0 vote199 views1 answer
Show specific events on mysql
SQL
0 vote157 views1 answer
Insert or update cassandra
SQL
0 vote172 views1 answer
Sql set data from a select query to a temp table and insert
SQL
0 vote164 views1 answer
On update current_timestamp jpa
SQL
0 vote169 views1 answer
VSCode SQL Server Connection error
SQL
0 vote233 views1 answer
Postgres extract number from string
SQL
0 vote179 views1 answer
Python sqlalchemy connection show server
SQL