9e0nybQK

1create table if not exists data
2(
3    pub integer,
4    text text,
5    data text
6)
7;
8	
9vk=# alter table data alter column data type json using data::json;
10ERROR:  invalid input syntax for type json
11DETAIL:  Token "owner_id" is invalid.
12CONTEXT:  JSON data, line 1: "{"owner_id...
13	
1456977566        {"text": "", "reposts": {"count": 0, "user_reposted": 0}, "date": 1512047929, "owner_id": -56977566, "post_type": "post", "likes": {"count": 4, "user_likes": 0, "can_like": 1, "can_publish": 1}, "copy_history": [{"text": "", "id": 122, "date": 1512047011, "owner_id": -134611619, "post_type": "post", "from_id": -134611619, "post_source": {"type": "vk"}, "attachments": [{"photo": {"text": "", "sizes": [{"height": 97, "type": "m", "width": 130, "url": "https://pp.userapi.com/c840431/v840431969/2ab19/lH-bN-Po3IY.jpg"}, {"height": 98, "type": "o", "width": 130, "url": "https://pp.userapi.com/c840431/v840431969/2ab1c/n6PShbOYKyQ.jpg"}, {"height": 150, "type": "p", "width": 200, "url": "https://pp.userapi.com/c840431/v840431969/2ab1d/ROS9hfm2fOw.jpg"}, {"height": 240, "type": "q", "width": 320, "url": "https://pp.userapi.com/c840431/v840431969/2ab1e/a3FjB17-49E.jpg"}, {"height": 383, "type": "r", "width": 510, "url": "https://pp.userapi.com/c840431/v840431969/2ab1f/CA_iZvMG-Rk.jpg"}, {"height": 56, "type": "s", "width": 75, "url": "https://pp.userapi.com/c840431/v840431969/2ab18/YpDd9W98tw0.jpg"}, {"height": 453, "type": "x", "width": 604, "url": "https://pp.userapi.com/c840431/v840431969/2ab1a/JolGqx6gG78.jpg"}, {"height": 480, "type": "y", "width": 640, "url": "https://pp.userapi.com/c840431/v840431969/2ab1b/W64cQiFgYZU.jpg"}], "id": 456239056, "date": 1512047011, "owner_id": -134611619, "album_id": -7, "access_key": "69803b042c79e136dc", "user_id": 100, "post_id": 122}, "type": "photo"}, {"type": "audio", "audio": {"genre_id": 1001, "artist": "u042du043cu0441u0438 u0430u0440u0442u0451u043c", "id": 456240948, "duration": 25, "owner_id": 2000350710, "title": "u041eu0441u043au0432u0435u0440u043du0438u0442u0435u043bu044c", "url": "https://vk.com/mp3/audio_api_unavailable.mp3", "date": 1512047011, "is_hq": false}}]}], "marked_as_ads": 0, "id": 6146, "comments": {"count": 7, "can_post": 1, "groups_can_post": true}, "views": {"count": 762}, "from_id": -56977566, "post_source": {"type": "api"}}