2012/4/23 Vincenzo Romano <vincenzo.romano@xxxxxxxxxxx>: > 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. Found! It is on chapter 9.4 select * from convert_from( decrypt( '\x864b9b7e89f7beda7030b3918811299f3489315f7818f594a16fb17461a12db5','fooz','aes' ),'UTF8' ); (sorry for bothering). -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
