Encrypt password postgresql

CREATE EXTENSION pgcrypto;

INSERT INTO users (email, password) VALUES (
  'johndoe@mail.com',
  crypt('johnspassword', gen_salt('bf'))
);

SELECT id 
  FROM users
 WHERE email = 'johndoe@mail.com' 
   AND password = crypt('johnspassword', password);

Source: x-team.com

Similar codes

0 vote249 views1 answer
Cannot start database server xampp mac os
SQL
0 vote238 views1 answer
Mysql database is not starting in xampp
SQL
3 votes282 views2 answers
Syntax error or access violation: 1701 Cannot truncate a table referenced in a foreign key constraint
SQL
0 vote272 views1 answer
Set column in all row mysql
SQL
0 vote251 views2 answers
Mysql password error create datbase
SQL
0 vote206 views2 answers
Denormalization in sql
SQL
1 vote251 views1 answer
Oracle apex run 404
SQL
2 votes280 views3 answers
How to check current user in mySQL
SQL
0 vote240 views1 answer
How to increase the width of the screen in oracle
SQL
5 votes243 views3 answers
Mysql check if null or empty string
SQL