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

8 votes149 views1 answer
Oracle create datafile
SQL
0 vote156 views1 answer
Java check if something is in mysql table
SQL
14 votes169 views3 answers
Inner join sql oracle
SQL
5 votes140 views1 answer
Postgresql functions
SQL
11 votes146 views3 answers
Sql_mode=only_full_group_by
SQL
0 vote146 views1 answer
Change date format in oracle query
SQL
0 vote143 views1 answer
Wordpress database query change url
SQL
0 vote170 views1 answer
"Hello User Name"
SQL
3 votes188 views1 answer
Dbms_scheduler drop_job
SQL
2 votes158 views1 answer
Import large .sql files into lampp
SQL