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 vote237 views1 answer
Sql getdate minus 1 day without time
SQL
6 votes246 views2 answers
Oracle
SQL
0 vote231 views1 answer
Add alternate add column sql
SQL
0 vote248 views1 answer
How to add timestamp column in mysql
SQL
0 vote246 views3 answers
Classement rang mysql 7
SQL
0 vote253 views1 answer
Sql pivot table
SQL
13 votes265 views3 answers
List all the tables in sql
SQL
2 votes242 views1 answer
Mysql create user with mysql_native_password
SQL
0 vote229 views1 answer
How to query all tables mysql at the same time
SQL
1 vote239 views1 answer
Postgresql reset serial counter after deleting content
SQL