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

Поиск

Список

Период

Сортировка

От	SQL Padawan
Тема	Pgcrypto extension - decrypt(encrypt(... not returning original data?
Дата	1 декабря 2021 г. 18:37:37
Msg-id	J8xQH_zNR9gNuRimbKUbEyEOarp51EazTCo4agf1xvWnLoQuiSCOhQ34uRzWz__AMWo1_Hw4xcb-SCMRf5-V_ZPc949iuZRIqQ0ODfeegnE=@protonmail.com обсуждение исходный текст
Ответы	Re: Pgcrypto extension - decrypt(encrypt(... not returning original data? Re: Pgcrypto extension - decrypt(encrypt(... not returning original data?
Список	pgsql-general

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 по дате отправления: