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 vote323 views2 answers
How to display enum value sql server
SQL
5 votes333 views1 answer
Minecraft java port number
SQL
0 vote326 views1 answer
Find and replace database table phpmyadmin
SQL
1 vote312 views1 answer
Oracle db create new schema
SQL
2 votes334 views2 answers
Postgres drop column if exists
SQL
0 vote327 views1 answer
Xampp increame mysql speed
SQL
16 votes337 views1 answer
Mssql int max value
SQL
0 vote336 views1 answer
Find how many tables in database sql query
SQL
2 votes333 views1 answer
Scaffold npgsql net core
SQL
1 vote337 views1 answer
Convert epoch to date in sql server
SQL