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 vote122 views1 answer
Convert int to varchar sql
SQL
10 votes227 views4 answers
Mysql if else
SQL
0 vote107 views1 answer
Restore backup "text" postgresql command line
SQL
0 vote137 views2 answers
How to list all values of a column that start with a letter in sql
SQL
27 votes118 views5 answers
Add column in table
SQL
0 vote121 views1 answer
Check if database exists sql
SQL
0 vote116 views1 answer
Shrink database file in sql server
SQL
0 vote116 views1 answer
Mysql streaming example
SQL
16 votes115 views2 answers
Sql exists
SQL
0 vote124 views1 answer
Configure: error: Cannot find libpq-fe.h. Please specify correct PostgreSQL installation path
SQL