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 vote133 views1 answer
Sql offfset
SQL
0 vote207 views1 answer
Mysql disable triggers
SQL
0 vote137 views1 answer
Delete ids between sql
SQL
5 votes137 views2 answers
Sql server port number
SQL
0 vote127 views1 answer
Oracle create job if not exists
SQL
0 vote137 views1 answer
Get substract count sql
SQL
7 votes137 views4 answers
Index in mysql
SQL
1 vote170 views1 answer
Insert many to many sql
SQL
0 vote139 views1 answer
Convert excel into sqllite db using python
SQL
0 vote138 views2 answers
Uncaught Error: Cannot use object of type mysqli_result as array
SQL