Re: Calling rest service from postgresql functions and stored proc

Поиск
Список
Период
Сортировка
От Magnus Hagander
Тема Re: Calling rest service from postgresql functions and stored proc
Дата
Msg-id CABUevExrmW4M3xDf+U-W7rmncN_ZHOcMkNz0uBZO9qOiSPVd+A@mail.gmail.com
обсуждение исходный текст
Ответ на Calling rest service from postgresql functions and stored proc  ("mahesh.sp" <mahes.sp@gmail.com>)
Список pgsql-general
Дерево обсуждения
On Thu, Feb 7, 2019 at 10:53 AM mahesh.sp <mahes.sp@gmail.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.
 
--

В списке pgsql-general по дате отправления:

Предыдущее
От: Ricardo Martin Gomez
Дата:
Сообщение: Re: Connection issue
Следующее
От: Pavel Stehule
Дата:
Сообщение: Re: Calling rest service from postgresql functions and stored proc