How to import values of a JSON to PostgreSQL?
You need to unnest the first level, and the second level in two steps:

Use jsonb_each() instead:

select d.val -&gt;&gt; 'value1' as value1,
       d.val -&gt;&gt; 'value2' as value2
from gugu g
  cross join jsonb_each(g.data) as d(ky,val);


Online example