create table house(js) as select jsonb ' { "info": { "contacts": "Postgres Professional\n+7 (495) 150-06-91\ninfo@postgrespro.ru", "dates": ["01-02-2015", "04-10-1957 19:28:34 +00", "12-04-1961 09:07:00 +03"] }, "address": { "country": "Russia", "city": "Moscow", "street": "117036, Dmitriya Ulyanova, 7A" }, "lift": false, "floor": [ { "level": 1, "apt": [ {"no": 1, "area": 40, "rooms": 1}, {"no": 2, "area": 80, "rooms": 3}, {"no": 3, "area": null, "rooms": 2} ] }, { "level": 2, "apt": [ {"no": 4, "area": 100, "rooms": 3}, {"no": 5, "area": 60, "rooms": 2} ] } ] } ';