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 vote245 views1 answer
Psql client write to bash variable
SQL
1 vote185 views1 answer
Login to database mysql terminal
SQL
0 vote196 views1 answer
How to drop columns with constraint from a table in sql script
SQL
0 vote238 views1 answer
Mysql last friday of current month
SQL
0 vote267 views1 answer
Inner join distinct
SQL
1 vote287 views3 answers
Showing all columns in an sqlite table
SQL
0 vote200 views3 answers
Above average salary in sql
SQL
1 vote192 views2 answers
Mysql order by date asc null last
SQL
0 vote214 views1 answer
Psql attribute cannot login
SQL
0 vote210 views1 answer
T-sql check if data exists
SQL