Postgres 13

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select version();

version

PostgreSQL 13.11 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-18), 64-bit

SELECT 1

CREATE EXTENSION pgcrypto;

CREATE EXTENSION

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

encrypt
pg_typeof
decrypt

\x54027d78b34ac951
bytea
\x6461

SELECT 1