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 vote128 views1 answer
Drop all tables in azure sql database
SQL
1 vote202 views1 answer
Mysql stop password policy
SQL
0 vote144 views1 answer
Mysql vs sql server performance benchmark
SQL
0 vote140 views1 answer
Mysql join same table multiple times group by
SQL
0 vote139 views1 answer
Sql query to delete row by id
SQL
1 vote141 views1 answer
CREATE DATABASE db; SyntaxError: Unexpected identifier
SQL
2 votes157 views1 answer
How to get non distinct values in sql
SQL
1 vote131 views1 answer
Error code 1055
SQL
19 votes165 views6 answers
Create table sqlite
SQL
0 vote135 views1 answer
Sql contains numeric characters
SQL