... and I noticed that the only password hashing option available in pgsql for authentication purposes is md5.
Is there any way to use something more reliable (bcrypt, scrypt, pbkdf2, or eventually any of the hashing schemes selected by the PHC https://password-hashing.net )?