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

2 votes182 views3 answers
Copy data from one table column to another table column in sql
SQL
3 votes231 views2 answers
Oracle privileges users
SQL
17 votes233 views2 answers
How to assign date field for table in mysql
SQL
0 vote158 views1 answer
Mysql earlier than date
SQL
1 vote182 views1 answer
Update from select join
SQL
0 vote183 views2 answers
Mysql missin expression near on
SQL
0 vote166 views1 answer
Openquery insert into linked server
SQL
2 votes169 views2 answers
Postgres trigger insert into another table
SQL
0 vote173 views1 answer
Sql select upcoming birthdays
SQL
0 vote173 views1 answer
Xampp mysql version
SQL