Table Of Contents
Using PostgreSQL Contribs
http extension for windows 64-bit
For those folks on windows who want to do http gets and posts directly from your PostgreSQL server, we've made binaries for the http extension v1.1.2 release for PostgreSQL 9.6, 9.5, and 9.4 Windows 64-bit.
We haven't gotten around to building the 32-bit variants but plan to and will add them here once done.
These should work fine on both PostgreSQL EDB windows distributions as well as the BigSQL windows 64 distributions. Instructions in the ReadMe.txt for where to copy the files to for each distribution. Caution should be taken especially with BigSQL to not overwrite existing BigSQL files. Many of the files in this already exist in the BigSQL distribution since we both compile using the Mingw64 chain.
If you have PostGIS already installed, many of these files you will also already have since things like the libcurl and PCRE are also packaged with PostGIS.
http extension binaries for PostgreSQL 9.6, 9.5, and 9.4 windows 64-bit downloads
The curl library for http is built with SSL support and utilizes the ssleasy.dll packaged with the EDB and BigSQL installs.
- PostgreSQL 9.6 w64 http (zip) 7z version
- PostgreSQL 9.5 w64 http (zip) 7z version
- PostgreSQL 9.4 w64 http (zip) 7z version
http quick primer
To enable in a database after having installed the binaries.
CREATE EXTENSION http;
Do a basic get
SELECT h.content, h.content_type, hkv.value As dt FROM http_get('http://postgis.net/tips/') AS h LEFT JOIN LATERAL (SELECT * FROM unnest(h.headers) WHERE field = 'Date') AS hkv ON true;
Check out more examples at: https://github.com/pramsey/pgsql-http