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 vote171 views2 answers
Create new table plsql
SQL
0 vote170 views1 answer
Insert or update sql query
SQL
7 votes161 views6 answers
Group_concat mysql
SQL
0 vote180 views1 answer
How to get one year old query from plan cache
SQL
-1 vote183 views1 answer
Adding a new table psql
SQL
0 vote181 views1 answer
Pl sql turn off variable substitution
SQL
1 vote189 views2 answers
Sql where is not number
SQL
5 votes177 views1 answer
Mysql count lines
SQL
0 vote175 views2 answers
Postgres show current role
SQL
-1 vote127 views1 answer
Oracle db list usernames
SQL