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

6 votes185 views2 answers
What is non relational database
SQL
0 vote244 views4 answers
Stored procedure sql
SQL
1 vote218 views1 answer
Ora-06502: pl/sql: numeric or value error: character string buffer too small
SQL
53 votes383 views6 answers
How to install mysql ubuntu
SQL
1 vote179 views1 answer
Sql server loop over query
SQL
0 vote145 views2 answers
Csv into data postgres
SQL
0 vote146 views1 answer
Top frequency in sql server
SQL
0 vote154 views1 answer
Sql find gaps in date ranges
SQL
0 vote145 views1 answer
Delete double on SQL with multiple primary keys
SQL
0 vote156 views1 answer
Sqlites studio red exclamation mark when poening databse
SQL