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 vote269 views1 answer
Sql case sttement with set
SQL
0 vote282 views1 answer
How to find symmetric pairs in sql
SQL
2 votes267 views1 answer
Add default sql server
SQL
7 votes280 views3 answers
Sql set
SQL
5 votes256 views2 answers
Mysql drop table cascade
SQL
0 vote246 views1 answer
Sql where time stamp is in between
SQL
8 votes236 views3 answers
Duplicate entry
SQL
0 vote286 views1 answer
How to select only a certain date sql
SQL
0 vote237 views1 answer
Postgres create database if not exists
SQL
1 vote283 views1 answer
Mysql print variable
SQL