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 vote159 views1 answer
Sql order by number not ordered
SQL
7 votes98 views1 answer
Alter table add key sql
SQL
3 votes120 views1 answer
Search for column name in psql
SQL
0 vote129 views1 answer
How to add session data into mysql database from button
SQL
0 vote127 views2 answers
How to relationship query two different tables in MySQL
SQL
0 vote121 views1 answer
Power bi find all ids not in other tables
SQL
16 votes128 views2 answers
Sql exists
SQL
0 vote136 views1 answer
Mysql local password denied
SQL
0 vote135 views2 answers
Timing sql queries
SQL
0 vote131 views1 answer
Delete data from database sqlite android
SQL