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 vote352 views1 answer
Sql composite key
SQL
0 vote326 views1 answer
Mysql:5.6 syntax create table
SQL
0 vote359 views1 answer
Insert or update sql firebird
SQL
0 vote357 views1 answer
Query to generate query to drop primary keys or foreign key in ms sql server
SQL
0 vote340 views1 answer
Check duplicate values plsql
SQL
0 vote329 views1 answer
Convert sql server guid to varbinary
SQL
6 votes785 views3 answers
Sql select last id
SQL
25 votes367 views3 answers
How to use a database to see tables mysql
SQL
0 vote375 views1 answer
Hue hive UploadingTextFiletoHive
SQL
37 votes348 views3 answers
Duplicate records in sql
SQL