[PostgreSql] 암호화(Encryption)

1. pgcrypto 설치

[root@localhost smoh]# yum install postgresql-contrib

2. 암호화

CREATE EXTENSION pgcrypto;

SELECT CRYPT('12345', GEN_SALT('md5'));

3. 검증

SELECT id FROM members WHERE id = 'id01' AND password = CRYPT('12345', password);

4. 전체 예시

CREATE EXTENSION pgcrypto;

DROP TABLE IF EXISTS members; 

CREATE TABLE members (

  id  TEXT  PRIMARY KEY,

  password TEXT

);

INSERT INTO members(id, password) VALUES ('id01', CRYPT('12345', GEN_SALT('md5')));

SELECT * FROM members;

--SELECT id FROM members WHERE id = 'id01' AND password = CRYPT('12345', password);