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

21 votes265 views3 answers
Search for column name in sql db when i don't know which table it is in
SQL
0 vote271 views1 answer
Sql datediff db2
SQL
0 vote283 views2 answers
Functions with parameters SQL
SQL
0 vote281 views1 answer
Excel export from sql using python
SQL
0 vote284 views1 answer
Mysql last friday of current month
SQL
0 vote238 views1 answer
SQL server select to get sum of hours
SQL
21 votes281 views1 answer
Cheatsheet for sql
SQL
0 vote323 views2 answers
How to check if a column exists in a SQL Server table?
SQL
1 vote270 views1 answer
"i_am_a_dummy flag" in MySQL
SQL
6 votes257 views1 answer
Oracle rank() over (partition)
SQL