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 votes140 views1 answer
Oracle sql day of month from date
SQL
0 vote111 views1 answer
Get last run query sql server
SQL
0 vote186 views1 answer
Mysql relationships between tables
SQL
0 vote153 views1 answer
How to check replication lag in mySQL
SQL
0 vote244 views4 answers
Stored procedure sql
SQL
2 votes203 views3 answers
3 days back in sql server
SQL
0 vote166 views3 answers
Run sql command line
SQL
0 vote151 views1 answer
Mysql DDL
SQL
0 vote164 views1 answer
SQLSTATE[01000]: Warning: 1265 Data truncated for column 'job_type' at row 1 (SQL: insert into
SQL
29 votes145 views5 answers
Mysql show table structure
SQL