Re: Calling rest service from postgresql functions and stored proc

On Thu, Feb 7, 2019 at 10:53 AM mahesh.sp <mahes(dot)sp(at)gmail(dot)com> wrote:

> Hi,
>
> Would like to know whether postgresql supports calling a rest service from
> function or stored procedure.
>
> Looking for Oracle to postgresql feasibility study.
>
> Searched in Google but could not find any official document regarding the
> same. Appreciate if inputs or reference links are shared or confirmed.
>
>
Absolutely. Pick any language capable of doing it (e.g. python, perl, v8/js
etc) and it will work fine. Depending on what the rest api looks like it
might also be a good idea to use something like multicorn to create a
foreign data wrapper to access it, thereby not needing a function or
procedure at all.

--
Magnus Hagander
Me: https://www.hagander.net/ <http://www.hagander.net/>
Work: https://www.redpill-linpro.com/ <http://www.redpill-linpro.com/>