Search Postgresql Archives

Pgcrypto extension - decrypt(encrypt(... not returning original data?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




I tried to use the pgcrypto extension.

from the manual.

https://www.postgresql.org/docs/14/pgcrypto.html

there are two functions - encrypt and decrypt - signatures as follows.

encrypt(data bytea, key bytea, type text) returns bytea
decrypt(data bytea, key bytea, type text) returns bytea

OK. 

I try to run this -- see a fiddle 

https://dbfiddle.uk/?rdbms=postgres_13&fiddle=d2c102f5fb6e62acb1c70a2dc755fdca


SELECT
  encrypt('da'::BYTEA, 'pw'::BYTEA, 'bf'),
  pg_typeof(encrypt('da'::BYTEA, 'pw'::BYTEA, 'bf')),
  decrypt(encrypt('da'::BYTEA, 'pw'::BYTEA, 'bf'), 'pw', 'bf');

but I get this as my result.

encrypt
pg_typeof
decrypt
\x54027d78b34ac951
bytea
\x6461


Why is my decrypt function not return the string 'da'? Have I not understand something important? 

SQLP!



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux