http extension for windows updated to include PostgreSQL17 64-bit (original) (raw)

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 are designed to work with PostgreSQL EDB windows distributions.

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 17, 16, 15, 14, 13, 12 11, 10, 9.6, 9.5, and 9.4 windows 64-bit downloads

PostgreSQL 10-14 64-bit are 1.5.0, other versions are older http versions.

The curl library for http is built with SSL support and utilizes the ssleasy.dll packaged with the EDB installs.

• PostgreSQL 17 w64 http (zip) 7z version
• PostgreSQL 16 w64 http (zip) 7z version
• PostgreSQL 15 w64 http (zip) 7z version
• PostgreSQL 14 w64 http (zip) 7z version
• PostgreSQL 13 w64 http (zip) 7z version
• PostgreSQL 12 w64 http (zip) 7z version
• PostgreSQL 11 w64 http (zip) 7z version
• PostgreSQL 10 w64 http (zip) 7z version
• 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 extension binaries for PostgreSQL 10, 9.6, 9.5, and 9.4 windows 32-bit downloads

• PostgreSQL 10 w32 http (zip) 7z version
• PostgreSQL 9.6 w32 http (zip) 7z version
• PostgreSQL 9.5 w32 http (zip) 7z version
• PostgreSQL 9.4 w32 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