Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT json_data->>'linename' l ,k ,json_data->>k v
- FROM copperline, lateral json_object_keys( json_data ) k WHERE json_data->>'linename' LIKE '40000100188';
- SELECT service_name,service_type,crm_customer_id, crm_contract_id , STATUS,k->'key' k,k->'value' v
- FROM service , lateral json_array_elements( json_data->'attributes' ) k
- WHERE service_type LIKE 'ACCESS%'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement