We are implementing the pgcrypto in our database to encrypt and decrypt the Column data. for testing purpose we have generate the PGP public / private key and use those when we read and write data.
How can we secure the key, if we keep the key outside how can we use that into query.