On Sun, Sep 25, 2016 at 4:55 AM, <j...@snikeris.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 -- Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs
