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 vote187 views1 answer
Postgres populate table from another table
SQL
1 vote180 views1 answer
Get table column names sql ssms
SQL
0 vote255 views1 answer
Authentication modes in sql server
SQL
3 votes245 views1 answer
Delete all content in table mysql
SQL
0 vote226 views1 answer
Postgres truncate with cascade
SQL
0 vote194 views1 answer
Mysql join column order By and group By
SQL
2 votes191 views1 answer
Enum in SQL Server
SQL
3 votes212 views3 answers
Sql current year
SQL
5 votes180 views1 answer
Postgresql functions
SQL
11 votes225 views2 answers
Sql rank
SQL