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 vote272 views1 answer
Postgresql alter table sequence
SQL
8 votes236 views1 answer
Mysql restore database
SQL
0 vote271 views3 answers
Characters found after end of sql statement
SQL
5 votes245 views2 answers
Get number of columns sql
SQL
0 vote229 views1 answer
Sql server python connection
SQL
0 vote257 views2 answers
Check if sql temp table exists
SQL
0 vote270 views1 answer
Add super privilege mysql
SQL
0 vote266 views1 answer
Mysql convert charset
SQL
0 vote247 views1 answer
Sql server change schema of a table
SQL
0 vote242 views1 answer
Create database like
SQL