uri

pig build pkg pg_uri;		# build rpm/deb

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

pig install pg_uri;		# install via package name, for the active PG version
pig install uri;		# install by extension name, for the current active PG version

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

CREATE EXTENSION uri;

CREATE EXTENSION uri;

CREATE TABLE links (
    id   int PRIMARY KEY,
    link uri
);

INSERT INTO links VALUES (1, 'https://github.com/petere/pguri');

-- Normalize URI per RFC 3986
SELECT uri_normalize('HTTP://Example.COM/foo/../bar');

-- Percent-encode text
SELECT uri_escape('hello world', true, false);  -- hello+world

-- Decode percent-encoded text
SELECT uri_unescape('hello+world', true, false);  -- hello world

SELECT uri_scheme(link), uri_host(link), uri_path(link)
FROM links
WHERE uri_host(link) = 'github.com';