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 vote128 views1 answer
Version_info, _mysql.version_info, _mysql.__file__ NameError: name '_mysql' is not defined
SQL
0 vote140 views1 answer
Arithmetic expression in sql
SQL
0 vote124 views1 answer
Mysql 1 hour ago
SQL
0 vote132 views1 answer
Oserror mysql_config not found virtualenv
SQL
0 vote127 views1 answer
Mysql changer nom table
SQL
0 vote134 views1 answer
Flexible search query delete table
SQL
14 votes141 views4 answers
Online sql compiler
SQL
0 vote128 views2 answers
Sql use not in
SQL
3 votes72 views2 answers
Mysql sum with condition
SQL
0 vote139 views1 answer
Redshift running queries
SQL