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 vote192 views1 answer
Mysql select utc time in eastern time
SQL
4 votes228 views3 answers
Mysql get column names from table
SQL
2 votes211 views1 answer
Oracle drop sequence if exists
SQL
1 vote214 views1 answer
Tsql get beginning of year
SQL
-1 vote201 views3 answers
MySQL shutdown unexpectedly
SQL
0 vote274 views1 answer
Sql select rows between 1000 and 2000
SQL
0 vote248 views1 answer
What is default mysql database password in linux
SQL
0 vote193 views1 answer
Syntax for changing column size in mysql
SQL
0 vote217 views1 answer
SQLSTATE[42000]: Syntax error or access violation: 1140 Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
SQL
0 vote286 views1 answer
SQL Server Enterprise
SQL