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 vote286 views5 answers
Postgresql difference between two dates in days
SQL
1 vote273 views1 answer
Mysql connect bash
SQL
7 votes260 views1 answer
Sql server convert string to date
SQL
1 vote268 views1 answer
Sql server list locks
SQL
2 votes253 views1 answer
Plsql block
SQL
2 votes202 views1 answer
Oracle current date without time
SQL
0 vote270 views1 answer
Kill mysqld_safe process mariadb
SQL
0 vote275 views1 answer
Oracle sql copy table without data
SQL
2 votes242 views1 answer
Mysql list users on ubuntu
SQL
1 vote265 views1 answer
Sql server cast date dd/mm/yyyy
SQL