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 vote338 views1 answer
Mysql date minus 1 day
SQL
3 votes346 views1 answer
Uppercase and lowercase in sql
SQL
0 vote334 views1 answer
Psql select * from table
SQL
2 votes319 views2 answers
Sqlite_busy: database is locked
SQL
1 vote342 views1 answer
Oracle drop chain step
SQL
1 vote324 views2 answers
Mysql insert generate serie
SQL
0 vote361 views3 answers
CONTACT FORM SQL
SQL
0 vote356 views1 answer
Mysql set variable to today's date
SQL
4 votes330 views2 answers
Sql table
SQL
0 vote304 views1 answer
Linux upload database to mysql
SQL