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 vote122 views1 answer
Mssql view column data type
SQL
0 vote167 views1 answer
(PDOException(code: 2002): SQLSTATE[HY000] [2002] Permission denied at
SQL
4 votes162 views1 answer
Force drop all tables postgres
SQL
3 votes165 views2 answers
Mysql time
SQL
0 vote186 views1 answer
Composit key in sql
SQL
1 vote177 views1 answer
Show structure of table in sql
SQL
0 vote166 views1 answer
Run sql script file and changes db name in this file using c#
SQL
0 vote175 views1 answer
How to query all tables mysql at the same time
SQL
5 votes217 views1 answer
How to get all table names in sql query
SQL
0 vote179 views2 answers
Advantages of stored procedures sql
SQL