SELECT https CURLOPT_CAINFO

DROP SCHEMA IF EXISTS extensions CASCADE;
CREATE SCHEMA IF NOT EXISTS extensions AUTHORIZATION postgres;
CREATE EXTENSION IF NOT EXISTS http WITH SCHEMA extensions;

SET http.timeout_msec = 59000;
SELECT
    extensions.http_set_curlopt
    (
        'CURLOPT_CAINFO',
        (SELECT
            format('%s/../../ssl/certs/curl-ca-bundle.crt',setting) AS setting
         FROM pg_settings WHERE name = 'data_directory')
);

--SELECT * FROM pg_settings WHERE  setting ~~* '%:/%';
--SELECT * FROM pg_settings WHERE  reset_val ~~* '%:/%';
--SELECT format('%s/',setting) AS setting FROM pg_settings WHERE  name = 'data_directory'
SELECT
  *
FROM extensions.http_get('https://pastebin.com/ypEEYqXd');