clear markdown compare help best fiddles feedback dbanow.uk a leap of faith?
clear markdown donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 2249108 fiddles created (32107 in the last week).

CREATE TABLE people("id" varchar(50), "data" jsonb,"firstName" text, "lastName" text)
 hidden batch(es)


update people set data = to_jsonb(data) || ('{"firstName": "' || MD5('PostgreSQL MD5') || '", "lastName": "' || MD5('PostgreSQL MD5') || '"}')::jsonb where id = 'b3c09005-7afb-4ad6-922d-76078875e59e';
 hidden batch(es)