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 vote103 views1 answer
Regular expression in sql server
SQL
0 vote112 views1 answer
SqlFunction does not exist
SQL
1 vote125 views1 answer
Sql group by sum with condition
SQL
11 votes106 views5 answers
How to install sqlite3 python
SQL
0 vote120 views1 answer
Testing sql queries
SQL
2 votes151 views3 answers
Xampp mysql database not starting
SQL
0 vote140 views1 answer
Sql create and grant user access to database
SQL
2 votes112 views1 answer
Update trigger
SQL
-1 vote98 views3 answers
Mysql get age from date
SQL
0 vote65 views1 answer
Select mysql limit to 2 decimal places
SQL