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

5 votes204 views3 answers
Mysql remove unique constraint
SQL
4 votes217 views1 answer
Oracle nls_date_format
SQL
-1 vote220 views1 answer
Mysql change database charset and collation
SQL
8 votes213 views10 answers
Sql
SQL
2 votes215 views1 answer
Grant revoke privileges to mysql username
SQL
0 vote214 views1 answer
Cast float mysql
SQL
1 vote222 views1 answer
Mysql average of multiple columns
SQL
0 vote194 views1 answer
Which is the order of precedence among following operator IN OUT AND OR in sql
SQL
0 vote194 views1 answer
Shrink database file in sql server
SQL
0 vote287 views1 answer
Alter database name script
SQL