How to convert BYTEA (from decrypt) to TEXT?

From: Vincenzo Romano <vincenzo(dot)romano(at)notorand(dot)it>
To: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: How to convert BYTEA (from decrypt) to TEXT?
Date: 2012-04-23 11:02:53
Message-ID: CAHjZ2x5Tg=rLN+6T1XYy7ONoG1fEpLcUStr9GLL166u_ZR399g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all.
I know that the output of a decrypt() call (from pgcrypto module) can
be safely converted to TEXT.
CAST( decrypt( data,key,'bf' ) as TEXT ) (and other variants) just doesn't work.
How can I (possibly easily) do it?
Thanks.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message AI Rumman 2012-04-23 11:31:07 What is the different between pg_trgm search and FULL Text search?
Previous Message fv967 2012-04-22 21:20:48 Re: Plpgsql 9.1.3 : not accepting "open", "close" as column names