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 vote219 views1 answer
How to avoid duplicate records in sqlite
SQL
3 votes246 views1 answer
DB: in eloquent using sql
SQL
0 vote221 views1 answer
Rows, INSERT INTO, Returning with alias
SQL
0 vote227 views1 answer
First Step in installing SQL workbench
SQL
0 vote250 views1 answer
Mysql Selected All Duplicate Rows
SQL
0 vote227 views1 answer
Mysql update from n to 100
SQL
0 vote230 views1 answer
Inserted row count tsql
SQL
0 vote232 views2 answers
How to set global time_zone in mysql
SQL
0 vote233 views1 answer
How to login to mysql in homestead
SQL
0 vote224 views1 answer
Docker open terminal mysql server
SQL