SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE users ( id integer, contact jsonb ); INSERT INTO users values (1, '{ "mainContact": {"name": "Timmy Tom","contactId": "11111", "phoneNumber": "+12345"}, "contactList": [ {"name": "Timmy Tom", "contactId": "11111", "phoneNumber": "+12345"}, {"name": "Robin Tom", "contactId": "11112", "phoneNumber": "+12345"}, {"name": "Jerry Tom", "contactId": "11113", "phoneNumber": "+12345"} ] }' ), (2, '{ "mainContact": {"name": "Timmy Bob","contactId": "21111", "phoneNumber": "+12345"}, "contactList": [ {"name": "Timmy Bob", "contactId": "21111", "phoneNumber": "+12345"}, {"name": "Robin Bob", "contactId": "21112", "phoneNumber": "+12345"}, {"name": "Jerry Bob", "contactId": "21113", "phoneNumber": "+12345"} ] }' ); SELECT * FROM users; SELECT json_array_elements(contact -> 'contactList') as contact_list from users;