{"action":"created","issue":{"url":"https://api.github.com/repos/lukasmartinelli/pgfutter/issues/12","repository_url":"https://api.github.com/repos/lukasmartinelli/pgfutter","labels_url":"https://api.github.com/repos/lukasmartinelli/pgfutter/issues/12/labels{/name}","comments_url":"https://api.github.com/repos/lukasmartinelli/pgfutter/issues/12/comments","events_url":"https://api.github.com/repos/lukasmartinelli/pgfutter/issues/12/events","html_url":"https://github.com/lukasmartinelli/pgfutter/issues/12","id":144659987,"number":12,"title":"incorrect JSON format","user":{"login":"bishopZ","id":1138587,"avatar_url":"https://avatars.githubusercontent.com/u/1138587?v=3","gravatar_id":"","url":"https://api.github.com/users/bishopZ","html_url":"https://github.com/bishopZ","followers_url":"https://api.github.com/users/bishopZ/followers","following_url":"https://api.github.com/users/bishopZ/following{/other_user}","gists_url":"https://api.github.com/users/bishopZ/gists{/gist_id}","starred_url":"https://api.github.com/users/bishopZ/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bishopZ/subscriptions","organizations_url":"https://api.github.com/users/bishopZ/orgs","repos_url":"https://api.github.com/users/bishopZ/repos","events_url":"https://api.github.com/users/bishopZ/events{/privacy}","received_events_url":"https://api.github.com/users/bishopZ/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2016-03-30T17:25:17Z","updated_at":"2016-03-30T17:34:13Z","closed_at":null,"body":"From the README \r\n\"A lot of event logs contain JSON objects nowadays (e.g. GitHub Archive). pgfutter expects each line to have a valid JSON object. Importing JSON is only supported for Postgres 9.3 and Postgres 9.4 due to the JSON type.\r\n\r\nCreate friends.json.\r\n\r\n{\"name\": \"Jacob\", \"age\": 26, \"friends\": [\"Anthony\"]}\r\n{\"name\": \"Anthony\", \"age\": 25, \"friends\": []}\r\n{\"name\": \"Emma\", \"age\": 28, \"friends\": [\"Jacob\", \"Anthony\"]}\"\r\n\r\nThis is not valid JSON. Please see http://json.org/ to see what I mean. \r\n\r\nAny plans to support properly formatted JSON?"},"comment":{"url":"https://api.github.com/repos/lukasmartinelli/pgfutter/issues/comments/203543269","html_url":"https://github.com/lukasmartinelli/pgfutter/issues/12#issuecomment-203543269","issue_url":"https://api.github.com/repos/lukasmartinelli/pgfutter/issues/12","id":203543269,"user":{"login":"lukasmartinelli","id":1288339,"avatar_url":"https://avatars.githubusercontent.com/u/1288339?v=3","gravatar_id":"","url":"https://api.github.com/users/lukasmartinelli","html_url":"https://github.com/lukasmartinelli","followers_url":"https://api.github.com/users/lukasmartinelli/followers","following_url":"https://api.github.com/users/lukasmartinelli/following{/other_user}","gists_url":"https://api.github.com/users/lukasmartinelli/gists{/gist_id}","starred_url":"https://api.github.com/users/lukasmartinelli/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/lukasmartinelli/subscriptions","organizations_url":"https://api.github.com/users/lukasmartinelli/orgs","repos_url":"https://api.github.com/users/lukasmartinelli/repos","events_url":"https://api.github.com/users/lukasmartinelli/events{/privacy}","received_events_url":"https://api.github.com/users/lukasmartinelli/received_events","type":"User","site_admin":false},"created_at":"2016-03-30T17:34:13Z","updated_at":"2016-03-30T17:34:13Z","body":"This is called JSONLines http://jsonlines.org/. Each line contains a valid JSON object.\r\nThe reason why this format is very good is that dealing with a 30GB big JSON file would be close to impossible.\r\n\r\nWhat is invalid about that JSON object?\r\n\r\n```json\r\n{\"name\": \"Jacob\", \"age\": 26, \"friends\": [\"Anthony\"]}\r\n```\r\n\r\nAt the bottom of the README you find how to import a single JSON document.\r\nhttps://github.com/lukasmartinelli/pgfutter#import-single-json-object"}}