http extension for windows 64 and 32-bit updated to include PostgreSQL13 64-bit
Updated January 6th, 2021 64-bit package for PostgreSQL 13 added http extension v1.3.1 release
Updated December15th, 2019 64-bit package for PostgreSQL 11, 10 updated to 1.3.1 and PostgreSQL 12 added http extension v1.3.1 release

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 for PostgreSQL Windows.

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.

Updated November 22nd, 2017 all packages updated to http extension v1.2.2 release

http extension binaries for PostgreSQL 13, 12 11, 10, 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.

http extension binaries for PostgreSQL 10, 9.6, 9.5, and 9.4 windows 32-bit downloads

http quick primer

To enable in a database after having installed the binaries.


Do a basic get

SELECT h.content, h.content_type, hkv.value As dt
FROM http_get('') AS h 
    FROM unnest(h.headers) 
        WHERE field =  'Date') AS hkv ON true;

Check out more examples at: