pgcurl

July 6, 2017 ยท View on GitHub

Call curl from PostgreSQL.

Requirements

  • PostgreSQL
  • libcurl

Installation

sh% make install
psql# create extension pgcurl;
psql# select curl('http://httpbin.org/get')::jsonb->'url';

Limitations

  • Only text at the moment (gzip/deflate uncompressed by libcurl)
  • Quite slow: fetches one url at a time
  • Errors are returned in-band
  • No options