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

-1 vote209 views3 answers
Unknown collation: 'utf8mb4_0900_ai_ci'
SQL
0 vote204 views1 answer
If column value is null then in mysql
SQL
0 vote232 views2 answers
Postgresql variable in query
SQL
0 vote185 views1 answer
Create table employees oracle
SQL
0 vote209 views1 answer
Query to count the number of rows in a table in sqlalchemy
SQL
20 votes228 views1 answer
Get all table name in sql through php
SQL
0 vote205 views1 answer
Python sqlalchemy orm to select null values
SQL
0 vote203 views1 answer
Mysql make date from 2 column
SQL
0 vote222 views4 answers
User defined function sql
SQL
0 vote204 views1 answer
Set column width in sqlplus
SQL