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!
