Hi,
I wanted to connect to Postgre database using postman and then try to compare the value returned in the API response with the value stored in the database. Please Help!
Thanks in Advance,
Nishant
1 Like
Hey @nishantnair77, you can use a tool like https://github.com/PostgREST/postgrest to setup a local REST API for your database, which can then be interacted with via Postman 
Use SOAPUI. It able connect to any database out of the box.
2 Likes
Hi 
Is there any example to do so? My API is on DEV and this is what I am trying to test. So I was wondering why do I need to setup a local REST API. It would be great if you could clarify. Thanks.
Not sure you will get much of a response here. This isn’t really a Postman issue.
Your probably need to find a Postgres forum for this type of question.
There doesn’t appear to be a direct http API for Postgres at this point in time.
The database connections are via a proprietary protocol FEBE
Therefore you would need to create your own API.
I did have a look at Azure Logic Apps as that is serverless and fairly easy to create your own API’s. However, that doesn’t appear to have a Postgres connector either.
Have a look at this which might be an option.
PostgreSQL: PostgreSQL RESTful API
That is from 2015, but I suspect there will be other (more modern) products out there that will allow you to create a RESTfull interface to the database without jumping through too many hoops. Suspect most will have a cost associated.