Postgres Pro
Downloads
Home   >   mailing lists

How to convert BYTEA (from decrypt) to TEXT? - Mailing list pgsql-general

From Vincenzo Romano
Subject How to convert BYTEA (from decrypt) to TEXT?
Date
Msg-id CAHjZ2x5Tg=rLN+6T1XYy7ONoG1fEpLcUStr9GLL166u_ZR399g@mail.gmail.com
Whole thread Raw
Responses Re: How to convert BYTEA (from decrypt) to TEXT?  (Vincenzo Romano <vincenzo.romano@notorand.it>)
List pgsql-general
Tree view 
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.

pgsql-general by date:

Previous
From: fv967
Date:
Subject: Re: Plpgsql 9.1.3 : not accepting "open", "close" as column names
Next
From: AI Rumman
Date:
Subject: What is the different between pg_trgm search and FULL Text search?