Hash using bcrypt
I already have user database with passwords using bcrypt hash
reference to https://lemonldap-ng.org/documentation/latest/authdbi.html
CREATE OR REPLACE FUNCTION sha256(varchar) returns text AS $$ SELECT encode(digest(decode($1, 'hex'), 'sha256'), 'hex') $$ LANGUAGE SQL STRICT IMMUTABLE;
how to encode a plaintext password using bcrypt instead of sha variant or md5 ?