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 vote345 views1 answer
Full outer join in mariadb mysql
SQL
0 vote340 views1 answer
Ms sql print more than 1 variable
SQL
1 vote328 views2 answers
Login to mysql
SQL
15 votes357 views4 answers
Sql update from select
SQL
-1 vote357 views5 answers
Convert sql to linq query online
SQL
0 vote339 views1 answer
Like date sql server not working
SQL
4 votes355 views1 answer
Oracle nls_date_format
SQL
0 vote352 views1 answer
Table user postgres
SQL
0 vote366 views1 answer
Get total and distict row diff in sql
SQL
0 vote337 views1 answer
Illuminate\Database\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'updated_at' in 'field list'
SQL