Pgcrypto extension - decrypt(encrypt(... not returning original data?
От
SQL Padawan
Тема
Pgcrypto extension - decrypt(encrypt(... not returning original data?
Дата
Msg-id
J8xQH_zNR9gNuRimbKUbEyEOarp51EazTCo4agf1xvWnLoQuiSCOhQ34uRzWz__AMWo1_Hw4xcb-SCMRf5-V_ZPc949iuZRIqQ0ODfeegnE=@protonmail.com
Список
Дерево обсуждения
Pgcrypto extension - decrypt(encrypt(... not returning original data? SQL Padawan <sql_padawan@protonmail.com>
Re: Pgcrypto extension - decrypt(encrypt(... not returning original data? Tom Lane <tgl@sss.pgh.pa.us>
Re: Pgcrypto extension - decrypt(encrypt(... not returning original data? Wim Bertels <wim.bertels@ucll.be>
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!
В списке pgsql-general по дате отправления
От: Wim Bertels
Дата:
