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 vote139 views1 answer
What is a Database?
SQL
0 vote149 views1 answer
Alter fedora mysql 8.0 user
SQL
0 vote105 views1 answer
Create duplicate table postgres
SQL
2 votes136 views1 answer
Get first n letter of department name in sql
SQL
11 votes167 views2 answers
Set default column value sql
SQL
15 votes144 views2 answers
Sql order by multiple columns
SQL
4 votes124 views1 answer
Invalid reference to FROM-clause entry for table "unidades
SQL
1 vote153 views1 answer
Code: "ER_TRUNCATED_WRONG_VALUE", errno: 1292, sqlMessage: "Incorrect date value: '2021-03-20T18:30:00.000Z' for column 'mgfdate' at row 1", sqlState: "22007", index: 0, …}
SQL
0 vote138 views1 answer
Sql server update top n records
SQL
2 votes142 views1 answer
Mysql Incorrect column specifier for column
SQL