pguecc

pig build pkg pg_ecdsa;		# build rpm/deb

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

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

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

CREATE EXTENSION pguecc;

SELECT ecdsa_make_key('secp256k1');
-- (public_key_hex, private_key_hex)

SELECT ecdsa_sign(
    '000000000000000000000000000000000000000000',  -- private key (hex)
    '1234',                                          -- data to sign
    'sha256',                                        -- hash function
    'secp160r1'                                      -- curve name
);

SELECT ecdsa_verify(
    '<public_key_hex>',
    'hello, world',
    '<signature_hex>',
    'sha256',
    'secp256k1'
);
-- t

SELECT ecdsa_is_valid_public_key('<public_key_hex>', 'secp256k1');
SELECT ecdsa_is_valid_private_key('<private_key_hex>', 'secp256k1');
SELECT ecdsa_is_valid_curve('secp256k1');  -- true

SELECT ecdsa_sign_raw(private_key_bytea, hash_bytea, 'secp256k1');
SELECT ecdsa_verify_raw(public_key_bytea, hash_bytea, signature_bytea, 'secp256k1');