Re: https call in PostgreSQL

From: "Nickerson, Jon (Analytics and Decision Support)" <jmnickerson(at)liberty(dot)edu>
To: bricklen <bricklen(at)gmail(dot)com>, "charlinbarak(at)gmail(dot)com" <charlinbarak(at)gmail(dot)com>
Cc: "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: https call in PostgreSQL
Date: 2018-05-11 17:24:12
Message-ID: BLUPR05MB1891A358E0F022553CA14DEBB09F0@BLUPR05MB1891.namprd05.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Howdy,

Take a look at this PG extension:

https://github.com/pramsey/pgsql-http

Also, here is a tutorial for that same extension:

https://boundlessgeo.com/2012/04/http-for-postgresql/

Jon Nickerson
Data Analyst II
Analytics and Decision Support

434-582-2933

[http://www.liberty.edu/media/1616/40themail/wordmark-for-email.jpg]

Liberty University | Training Champions for Christ since 1971

________________________________
From: bricklen <bricklen(at)gmail(dot)com>
Sent: Friday, May 11, 2018 1:18 PM
To: charlinbarak(at)gmail(dot)com
Cc: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: https call in PostgreSQL

On Fri, May 11, 2018 at 8:30 AM Charlin Barak <charlinbarak(at)gmail(dot)com<mailto:charlinbarak(at)gmail(dot)com>> wrote:
In Oracle, we use the UTL_HTTP package to make a https call within the database. Is there an equivalent in PostgreSQL?

The following might work for you:
https://github.com/pramsey/pgsql-http<https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fpramsey%2Fpgsql-http&data=02%7C01%7Cjmnickerson%40liberty.edu%7Cbb19ca5b26cb4363212308d5b76365ba%7Cbaf8218eb3024465a9934a39c97251b2%7C0%7C0%7C636616559900223550&sdata=zUpQlD%2F7Wc7yQ0UcXoPw5tQNk2vH1RvWZiss1%2BhTrEI%3D&reserved=0>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2018-05-11 18:25:39 Re: https call in PostgreSQL
Previous Message bricklen 2018-05-11 17:18:40 Re: https call in PostgreSQL