Qunar Tech Salon

May 5, 2015 · Databases

Encrypting Sensitive Data with PostgreSQL pgcrypto

This article explains how to protect user privacy by using PostgreSQL's built-in pgcrypto extension to encrypt and decrypt sensitive fields such as phone numbers and ID numbers, showing practical SQL examples for creating tables, altering columns, storing ciphertext, and querying encrypted data.