Sample Header Ad - 728x90

searching against decrypted column

1 vote
1 answer
2651 views
I'm using Postgres on AWS RDS. My application is encrypting selected columns in a table using AWS KMS encryption. I tried but could not find a way to configure KMS keys and use the decrypt() in select query. For example, my app is encrypting myTable.secureColumn using KMS. Now, I'm trying to fire below query: select * from myTable where decrypt(secureColumn, 'key', 'aes') = 'data'; I didn't find how to configure KMS keys in pgCrypto and use in above query. Has anyone tried this? Thanks in advance.
Asked by Java Spring Coder (113 rep)
Feb 5, 2017, 05:01 AM
Last activity: Jul 21, 2017, 01:23 PM