copy jsonb data to table row

jsonb_to_table_row.sql

select agreement_uuid, term->'uuid' from new_agreements
  CROSS JOIN LATERAL jsonb_array_elements(royalties_terms) term
 where id = 26
 
create type royalties_terms as (uuid text);
select term.*, agreement_uuid as new_agreement_uuid from new_agreements
  CROSS JOIN LATERAL jsonb_populate_recordset(null::agreements_royalty_terms, royalties_terms) term
 where id = 26

 
INSERT INTO agreements_royalty_terms (
        uuid,
...
      )
      SELECT
        term.uuid,
...
      FROM
        new_agreements
      CROSS JOIN LATERAL JSONB_POPULATE_RECORDSET(NULL::agreements_royalty_terms, royalties_terms) term
where
	id = 26
 
drop type term_type

select * from pg_type;