pg_pwhash

pig repo add pgdg -u    # add pgdg repo and update cache

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

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

CREATE EXTENSION pg_pwhash;

CREATE EXTENSION pg_pwhash;

-- Argon2id (recommended)
SELECT pwhash_crypt('password', pwhash_gen_salt('argon2id'));
-- $argon2id$v=19$m=4096,t=3,p=1$<salt>$<hash>

-- Scrypt
SELECT pwhash_crypt('password', pwhash_gen_salt('scrypt'));

-- Yescrypt
SELECT pwhash_crypt('password', pwhash_gen_salt('yescrypt'));

-- Hash matches if output equals stored hash
SELECT stored_hash = pwhash_crypt('entered_password', stored_hash) AS valid;

SELECT pwhash_argon2('password', pwhash_gen_salt('argon2id'));
SELECT pwhash_scrypt('password', pwhash_gen_salt('scrypt'));
SELECT pwhash_yescrypt_crypt('password', pwhash_gen_salt('yescrypt'));

-- Argon2 with custom memory/time/parallelism
SELECT pwhash_gen_salt('argon2id', 'm=65536', 't=4', 'p=2');

-- Scrypt with custom parameters
SELECT pwhash_gen_salt('scrypt', 'ln=20', 'r=8', 'p=1');