qk3tydCP

1create extension if not exists pgcrypto;
2	
3create table my_table(id serial primary key, data jsonb);
4insert into my_table (data) values
5('{"key": "value"}');
6
7alter table my_table
8    alter data type bytea 
9    using pgp_sym_encrypt(data::text, 'secret_password');
10
11select pgp_sym_decrypt(data, 'secret_password')
12from my_table;
13
14 pgp_sym_decrypt  
15------------------
16 {"key": "value"}
17(1 row)