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

4 votes185 views1 answer
Find tables with column name in sql
SQL
18 votes187 views6 answers
Drop table if exists
SQL
0 vote201 views1 answer
Create view in sql server that contain multiple select statements
SQL
0 vote193 views2 answers
Identity column in sql server
SQL
0 vote183 views1 answer
Groupby error in mysql
SQL
0 vote182 views1 answer
Restore backupfile discourse
SQL
0 vote189 views1 answer
CALCULATING MONTHS BETWEEN TWO DATES IN POSTGRESQL
SQL
3 votes186 views1 answer
Mysql set field unique
SQL
0 vote198 views1 answer
Reset keys in sql
SQL
0 vote235 views1 answer
Add week ending date sql server
SQL