querying a JSOn object in separate columns from Postgres table
You can extract each array element using the-&gt;&gt; operator:
select request_id,
       job_info -&gt;&gt; 0 as cluster_1, 
       job_info -&gt;&gt; 1 as cluster_2
from requests_table 
where cast(job_id as varchar) like '%4665-b583-3b92218db8ce%'