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 vote30 views1 answer
Convert rows to columns in sql server
SQL
0 vote41 views1 answer
SQL Cut part string
SQL
-1 vote31 views1 answer
Mysql select count if contains
SQL
0 vote36 views2 answers
Add colum in sql
SQL
34 votes26 views5 answers
Oracle alter table add column
SQL
0 vote35 views1 answer
Postgresql using reserved word as column name
SQL
0 vote30 views1 answer
Raiserror with nowait
SQL
1 vote38 views3 answers
Drop unique key constraint in sql server
SQL
0 vote31 views1 answer
Insert into using contant values and source table columns with sql
SQL
1 vote31 views1 answer
Woocommerce mysql price table
SQL