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

4 votes177 views1 answer
Ms sql truncate table vs delete
SQL
0 vote141 views1 answer
Teller stamp , bmo , PDF
SQL
0 vote156 views3 answers
Sql select statements
SQL
3 votes132 views1 answer
Sql timestamp to date
SQL
1 vote155 views2 answers
Sql server concat string and int
SQL
6 votes144 views3 answers
How to delete table sqlite
SQL
5 votes177 views1 answer
FSADeprecationWarning: SQLALCHEMY_TRACK_MODIFICATIONS adds significant overhead and will be disabled by default in the future. Set it to True or False to suppress this warning.
SQL
21 votes144 views3 answers
Sql average
SQL
0 vote150 views1 answer
Create table in mysql mariadb primary key foreign key
SQL
0 vote134 views1 answer
Postgresql certain first 4 characters in string
SQL