How to convert BYTEA (from decrypt) to TEXT?

Поиск
Список
Период
Сортировка
От Vincenzo Romano
Тема How to convert BYTEA (from decrypt) to TEXT?
Дата
Msg-id CAHjZ2x5Tg=rLN+6T1XYy7ONoG1fEpLcUStr9GLL166u_ZR399g@mail.gmail.com
обсуждение исходный текст
Ответы Re: How to convert BYTEA (from decrypt) to TEXT?
Список 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.

В списке pgsql-general по дате отправления: