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 votes318 views1 answer
Install postgresql centos 5
SQL
0 vote273 views1 answer
Mysql select all table that have field names
SQL
0 vote297 views1 answer
Influxdb clone measurement
SQL
0 vote300 views2 answers
Get item by composite primary key mysql
SQL
0 vote297 views1 answer
Mysql random number between 1 and 100
SQL
6 votes330 views2 answers
Install psql mac
SQL
0 vote283 views1 answer
Mac os zsh: command not found: mysql
SQL
0 vote262 views1 answer
Oracle create package body
SQL
1 vote279 views1 answer
Increasing font and zooming in mysql workbench
SQL
3 votes269 views1 answer
Postgres update column with value from another table
SQL