DB lab7

CREATE TABLE table_name (json_value json);
INSERT INTO table_name VALUES ('{"name":"me"}');
delete from table_name;
UPDATE table_name SET json_value = '{"name":"you"}';
select * from table_name;


CREATE TABLE families_j (id serial PRIMARY KEY, profile json);

INSERT INTO families_j (profile) VALUES (
    '{"name":"Gomez", "members":[
        {"member":{"relation":"padre", "name":"Alex"}},
        {"member":{"relation":"madre", "name":"Sonia"}},
        {"member":{"relation":"hijo", "name":"Brandon"}},
        {"member":{"relation":"hija", "name":"Azaleah"}}
    ]}');

SELECT json_array_length(profile->'members') AS num, json_array_elements(profile->'members')#>>'{member, name}'