patternsqlMinor
Postgresql row-level encryption
Viewed 0 times
postgresqllevelrowencryption
Problem
Looking over the docs, I didn't see any mention of row-level encryption.
Lets assume I have a database of highly classified information that needs to get locked down. How can I implement a table with row-level encryption in postgres? Failing row-level, what's the next best thing I can do, and what are the drawbacks?
Lets assume I have a database of highly classified information that needs to get locked down. How can I implement a table with row-level encryption in postgres? Failing row-level, what's the next best thing I can do, and what are the drawbacks?
Solution
Usually, you don't want to do this. Have you given second thoughts to this?
Else, pg_crypto is your friend. But as the above-mentioned slides suggest, it isn't necessarily a panacea.
Else, pg_crypto is your friend. But as the above-mentioned slides suggest, it isn't necessarily a panacea.
Context
StackExchange Database Administrators Q#3585, answer score: 5
Revisions (0)
No revisions yet.