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 vote298 views1 answer
Plpgsql if statement
SQL
16 votes292 views1 answer
CTE statement sql server
SQL
5 votes265 views1 answer
Alter table default value mysql
SQL
1 vote331 views1 answer
Psql filed name alter
SQL
2 votes326 views1 answer
Sql server current date minus 5 years
SQL
0 vote318 views1 answer
Mysql join column order By and group By
SQL
0 vote322 views2 answers
Create row number in sql
SQL
0 vote317 views1 answer
SQL Server Enterprise
SQL
0 vote294 views1 answer
Adonisjs ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
24 votes288 views5 answers
Sql reset auto increment
SQL