CREATE TABLE pjson_table (myjson json);

INSERT INTO pjson_table VALUES('[ { "major" : "International business", "end" : "2007", "name" : "Annamalai University", "degree" : "Master Degree", "start" : "2005", "desc" : "" }, { "major" : "Mechanical Engineering", "end" : "1990", "name" : "Bharathidasan University", "degree" : "Bachelor Degree", "start" : "1990", "desc" : "" } ]')

select * from pjson_table

SELECT x.* FROM pjson_table , json_to_recordset(myjson::json) x ( major text , "end" text , name text , degree text , start text )