Consume REST API from a PL (Postgresql 11)

Asked

Viewed 144 times

0

Hello,

I am working on a project in which I must build a PL that should consume a REST service (return in JSON). Looking at the Postgresql documentation, I did not find equivalent functions to UTL_HTTP oracle.

I found some tutorials where the DBA built the PL using PL/Python to make HTTP requests.

Postgresql does not have native HTTP request support?

database postgresql pl-sql dbase

  • I can’t say, but I suspect I don’t. I’m surprised that Oracle does. A threadless HTTP request would end the bank’s responsiveness. If you need to do this, it may be evidence that there is something very wrong with your requirement. Who should call the Web Apis is the application in the backend. See: https://stackoverflow.com/a/12669205/2241463

1 answer

0

A solution based on Postgrest. This tool acts by providing the API, has HTTP support and meets this type of request.

One important detail: Replies to requests are returned in JSON

Browser other questions tagged database postgresql pl-sql dbase

You are not signed in. Login or sign up in order to post.