Answers for "encrypt password postgresql"

SQL
1

encrypt password postgresql

CREATE EXTENSION pgcrypto;

INSERT INTO users (email, password) VALUES (
  '[email protected]',
  crypt('johnspassword', gen_salt('bf'))
);

SELECT id 
  FROM users
 WHERE email = '[email protected]' 
   AND password = crypt('johnspassword', password);
Posted by: Guest on November-22-2021

Code answers related to "encrypt password postgresql"

Code answers related to "SQL"

Browse Popular Code Answers by Language