On Tue, Jul 3, 2018 at 6:17 AM, ROS Didier <didier.ros@edf.fr> wrote:
Hi
I Would like to know how to encrypt data with physical public key files. I can’t find any documentation about this subject.
Thanks in advance
This isn't really a suitable question for pgsql-hackers, as you aren't talking about development of the PostgreSQL system itself, but rather usage of that system. That type of question should probably go to pgsql-general.
I don't know what it means for a key file to be "physical". Does that mean stored on disk?
The functions you get from pgcrypto extension do not automatically detect the format of the key file, so you have to de-armor them explicitly if they are stored in base64. I wish it would detect that. I just do it on the fly.
Here is a program I have used for testing and benchmarking pgcrypto, perhaps you would find it useful as an example.