-- curl "https://graph.facebook.com/v2.0/me/likes?limit=2000&access_token=<MYTOKEN>" -o mylikes.json

create table facebook (data json);

\COPY facebook FROM 'mylikes.json'

select json_array_elements(data->'data') from facebook ;

select distinct likes->>'category' as cat, likes->>'name' as name from (select json_array_elements(data->'data') as likes from facebook ) as fb where likes->>'category' = 'University';