pg_net

pig build pkg pg_net;		# build rpm/deb

pig repo add pgsql -u   # add both repo and update cache

pig install pg_net;		# install via package name, for the active PG version

pig install pg_net -v 18;   # install for PG 18
pig install pg_net -v 17;   # install for PG 17
pig install pg_net -v 16;   # install for PG 16
pig install pg_net -v 15;   # install for PG 15
pig install pg_net -v 14;   # install for PG 14

shared_preload_libraries = 'pg_net';

CREATE EXTENSION pg_net;

SELECT net.http_get('https://postman-echo.com/get?foo=bar') AS request_id;

SELECT net.http_get(
  'https://postman-echo.com/get',
  params := '{"foo": "bar"}'::JSONB,
  headers := '{"API-KEY": "<key>"}'::JSONB
) AS request_id;

SELECT net.http_post(
    'https://postman-echo.com/post',
    '{"key": "value"}'::JSONB,
    headers := '{"Content-Type": "application/json"}'::JSONB
) AS request_id;

WITH row AS (SELECT * FROM my_table LIMIT 1)
SELECT net.http_post(
    'https://api.example.com/data',
    to_jsonb(row.*)
) AS request_id
FROM row;

SELECT net.http_delete('https://api.example.com/resource/42') AS request_id;

SELECT * FROM net._http_response;

SHOW pg_net.batch_size;       -- default: 200, max rows processed per cycle
SHOW pg_net.ttl;              -- default: 6 hours, response retention time
SHOW pg_net.database_name;    -- default: 'postgres'

ALTER SYSTEM SET pg_net.ttl TO '1 hour';
ALTER SYSTEM SET pg_net.batch_size TO 500;
SELECT pg_reload_conf();