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 votes113 views1 answer
Mysql clear screen
SQL
0 vote126 views1 answer
Play framework connection via windows sql server
SQL
0 vote121 views1 answer
Create database like
SQL
0 vote108 views2 answers
Csv into data postgres
SQL
7 votes114 views2 answers
Html to react converter
SQL
0 vote101 views1 answer
Openquery insert into linked server
SQL
16 votes107 views4 answers
Mysql import from sql file
SQL
0 vote72 views1 answer
Hangfire clean script
SQL
1 vote106 views1 answer
Oracle get current schema
SQL
0 vote128 views2 answers
How to see table associated with a schema in sql
SQL