Hi,
We have web application and encrypt PII columns. We use encrypt/decrypt function for this.
Currently we hard coded the key in postgresql function which I am not sure of it.
I did google it and people suggest that it needed to be stored in physically isolated location (storing decryption key on the same server as the data is kind of like writing your PIN on your ATM card).
I would like to know how postgres professionals handles this.
Thank you very much for your time in advance.
Naoko