SQLize Online / PHPize Online  /  SQLtest Online

create table s ( id int, status text ); insert into s values (1, 'lock'), (2, 'read'), (3, 'write'); select * from s; create table u ( id int, a int, b int, c int ); insert into u values (1, 1, 1, 2), (2, 3, 2, 1 ); select '{"1":"lock", "2":"read", "3":"write"}'::jsonb statuses, * , jsonb_extract_path(statuses, a::text) a_status from u; with s1 as ( -- select json_agg(s.*) from s select '{"1":"lock", "2":"read", "3":"write"}'::jsonb statuses ) select * , jsonb_extract_path(statuses, a::text) a_status from s1 cross join u;