Re: PostgreSQL equivalent of UTL_HTTP

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: PostgreSQL equivalent of UTL_HTTP
Дата
Msg-id CAFj8pRCupU0uRbNrNBxN1_3-z0sCE+wFUidRH_RSKZya3SFcHg@mail.gmail.com
обсуждение исходный текст
Ответ на PostgreSQL equivalent of UTL_HTTP  (aditya desai <admad123@gmail.com>)
Список pgsql-performance
Дерево обсуждения
Hi

st 11. 8. 2021 v 20:57 odesílatel aditya desai <admad123@gmail.com> napsal:
Hi,
We are migrating Oracle to PostgreSQL. We need the equivalent of UTL_HTTP.
How to invoke Web service from PostgreSQL.

Also please let me know the PostgreSQL equivalents of below Oracle utilities..

utl.logger,UTL_FILE,UTL_SMTP


You can use an routines in untrusted PLPerl or untrusted PLPython, but these routines can be really unsafe (due possibility to break signal handling).

Personally, I think using http access in stored procedures is a very bad idea - access from transactional to non-transactional (and possibly pretty slow) environments creates a lot of ugly problems. Stored procedures are great technology with a pretty bad reputation, and one reason why is usage of this technology for bad cases.

I think this mailing list is wrong for this kind of question. There is no relation to performance.

Regards

Pavel





Regards,
Aditya.


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