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 vote205 views1 answer
Sql query inline if
SQL
0 vote179 views1 answer
Apache Derby: Create SQL Dump with data
SQL
0 vote222 views1 answer
Drop domain postgresql
SQL
1 vote191 views1 answer
Mysql dump specific tables
SQL
1 vote182 views1 answer
Mysql select another database
SQL
2 votes192 views2 answers
How to run postgresql in linux
SQL
6 votes175 views5 answers
Mysqli_real_connect(): (HY000/1698): Access denied for user 'root'@'localhost'
SQL
0 vote236 views1 answer
Mysql trigger to delete old data
SQL
6 votes179 views2 answers
If not exists insert sql
SQL
-1 vote135 views2 answers
On delete set default sql server
SQL