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

5 votes294 views1 answer
Purge undo tablespace oracle 11g
SQL
2 votes296 views1 answer
How to get weekday from old date in sql
SQL
1 vote281 views1 answer
Oracle user last connected
SQL
0 vote290 views1 answer
Find wordpress version in database
SQL
0 vote266 views1 answer
Cara menampilkan tabel yang tidak mengandung kata di sql server
SQL
4 votes292 views3 answers
Oracle sql first day of quarter
SQL
4 votes293 views1 answer
Add constraint fk
SQL
-1 vote315 views1 answer
Utf8_encode mysql
SQL
-1 vote312 views1 answer
Sql select data from one database and insert into a different database
SQL
2 votes300 views4 answers
Sql query interview questions
SQL