We started with Q&A. Technical documentation is next, and we need your help.
Whether you're a beginner or an experienced developer, you can contribute.
|
I am trying to encrypt a Postgres table column using my own algorithms. I am reading rsa key from file and encrypting data using algorithms. My column type is bytea. When I try to insert encrypted data the Postgres gives the following error:
I tried few options setting encoding as found on internet but did not work. I don't know what is causing this error. |
||||
|
|
|
The problem is that you are trying to store binary data in a string ( PostgreSQL rejects data that do not match the encoding set by the parameter The solution is to use a column of type |
|||||||||
|
|
The salient part of your code consists of these lines: So because you're trying to pass binary contents directly in the text of a query. The value must be encoded in a text representation to be injected as a literal into the query's values clause. This should be done with the |
|||||
|
