pgjwt

pig build pkg pgjwt;		# build rpm/deb

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

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

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

CREATE EXTENSION pgjwt CASCADE; -- requires pgcrypto

SELECT sign(
    '{"sub":"1234567890","name":"John Doe","admin":true}',
    'secret'
);

SELECT * FROM verify(
    'eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJzdWIiOiIxMjM0NTY3ODkwIiwibmFtZSI6IkpvaG4gRG9lIiwiYWRtaW4iOnRydWV9.TJVA95OrM7E2cBab30RMHrHDcEfxjoYZgeFONFh7HgQ',
    'secret'
);

SELECT sign('{"data":"value"}', 'secret', 'HS384');