From: | Kevin Grittner <kgrittn(at)gmail(dot)com> |
---|---|
To: | joe(at)snikeris(dot)com |
Cc: | "pgsql-docs(at)postgresql(dot)org" <pgsql-docs(at)postgresql(dot)org> |
Subject: | Re: Documentation for pgp_pub_decrypt |
Date: | 2016-09-26 18:19:40 |
Message-ID: | CACjxUsMwjey7tCm1aKoMfHXLSUTuoLWHeir_7=HaNQa26maqFw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-docs |
On Sun, Sep 25, 2016 at 4:55 AM, <joe(at)snikeris(dot)com> wrote:
> I believe the first argument [apparently of pg_sym_decrypt() and
> pg_pub_decrypt()] should be of type 'text'. Especially
> considering the paragraph that follows discusses how passing in
> bytea is disallowed.
The *encrypted* form is bytea; those functions *return* text and
are thus not a good way to get back to unencrypted bytea data; an
additional transformation would still be required to get to the
byte format from text, and the bytes representing those character
strings would depend on the character encoding.
--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2016-09-26 19:44:37 | Re: Documentation for pgp_pub_decrypt |
Previous Message | Tom Lane | 2016-09-26 15:51:33 | Re: Undocumented function: has_type_privilege() |