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 vote339 views1 answer
Query for backup a database at another location in file system
SQL
0 vote313 views1 answer
Sql where part of string match
SQL
0 vote302 views1 answer
Sql select min
SQL
1 vote342 views1 answer
How to see logical reads in sql server
SQL
1 vote306 views1 answer
Psql autocomplete for mac brew install
SQL
0 vote292 views1 answer
Heidisql check how much space a row
SQL
0 vote321 views2 answers
Mysql update two tables at once
SQL
0 vote343 views1 answer
How to use sqlcommand
SQL
0 vote287 views1 answer
Sql query to select records entered in last 24 hours
SQL
0 vote325 views2 answers
Sql stored procedure for access frontend
SQL