PostgreSQL Extension - pgcrypto
PostgreSQL Password column Encryption & Decryption use Master Key: Step 1: create an extension pearl=# create extension pgcrypto ; Step 2: create test table pearl=# create table test (id numeric, password text); Step 3: insert the value use encryption use master key pearl=# insert into test values (1, pgp_sym_encrypt('0912345678'::text,'IJljCQyuuPyBvJMuTH0v'::text)); Step 4: Select or Decrypt the data Decrypt the data use wrong master key: ...