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

3 votes316 views1 answer
Force using index oracle
SQL
1 vote325 views3 answers
Union in sql
SQL
2 votes354 views2 answers
Mysql bidirectional composite primary key
SQL
13 votes297 views2 answers
Display users in mysql
SQL
1 vote326 views1 answer
Trim leading zeros in sql
SQL
0 vote318 views1 answer
Sql Top 5 sutradara dengan filem terbanyak
SQL
0 vote302 views1 answer
Postgresql update to unique
SQL
1 vote337 views1 answer
Sql string function update replace
SQL
0 vote324 views1 answer
Openquery insert into linked server
SQL
3 votes332 views2 answers
Search text in all sql server stored procedure
SQL