How to encrypt columns in postgresql?

Question

I'm new to PostgreSQL and never worked with encryption. I read some links about encryption in PostgreSQL, like this one, but I'm a little bit confused about what it wants to say (or what I understand:)). Can you guide me with some thoughts or links in this problem?

Thanks.

Why not buy a book about encryption first? I've downvoted this message for the simple reason that it is way too open. — Maarten Bodewes
– Maarten Bodewes, Commented Dec 7, 2011 at 10:53

Chris Travers · Accepted Answer · 2012-10-10 06:23:56Z

8

Look into the pgcrypto addon. Note that db-level cryptography is tricky. You have key management issues that are not trivial to resolve. In general if you really need this, it is probably worth hiring a professional consultant to do some code review and another one to provide some design review ahead of time.

In general, I don't recommend doing all your encryption in the db at present unless it is required due to regulatory or similar regimes.

answered Oct 10, 2012 at 6:23

Chris Travers

26.6k6 gold badges70 silver badges191 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Tom van der Woerdt · Accepted Answer · 2011-12-27 17:30:56Z

-7

You can encrypt data by using md5 ex like md5(your colunn name)

edited Dec 27, 2011 at 17:30

Tom van der Woerdt

30k7 gold badges76 silver badges105 bronze badges

answered Dec 26, 2011 at 10:54

Selva Kumar K.P.

1,1073 gold badges10 silver badges10 bronze badges

1 Comment

William Brendel Over a year ago

MD5 is not encryption. It's a hashing function, and a poor one by today's standards.

Collectives™ on Stack Overflow

How to encrypt columns in postgresql?

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related