I tried to use the pgcrypto extension.
from the manual.
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
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!