{"action":"created","issue":{"url":"https://api.github.com/repos/rstats-db/RPostgres/issues/18","labels_url":"https://api.github.com/repos/rstats-db/RPostgres/issues/18/labels{/name}","comments_url":"https://api.github.com/repos/rstats-db/RPostgres/issues/18/comments","events_url":"https://api.github.com/repos/rstats-db/RPostgres/issues/18/events","html_url":"https://github.com/rstats-db/RPostgres/issues/18","id":59393367,"number":18,"title":"Support for Postgres data type JSON","user":{"login":"mbannert","id":1382079,"avatar_url":"https://avatars.githubusercontent.com/u/1382079?v=3","gravatar_id":"","url":"https://api.github.com/users/mbannert","html_url":"https://github.com/mbannert","followers_url":"https://api.github.com/users/mbannert/followers","following_url":"https://api.github.com/users/mbannert/following{/other_user}","gists_url":"https://api.github.com/users/mbannert/gists{/gist_id}","starred_url":"https://api.github.com/users/mbannert/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mbannert/subscriptions","organizations_url":"https://api.github.com/users/mbannert/orgs","repos_url":"https://api.github.com/users/mbannert/repos","events_url":"https://api.github.com/users/mbannert/events{/privacy}","received_events_url":"https://api.github.com/users/mbannert/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":3,"created_at":"2015-03-01T11:59:21Z","updated_at":"2015-03-01T20:39:15Z","closed_at":null,"body":"It's rather a suggestion than an issue, but I'd love to see json support in an RPostgres package.\r\nThe current CRAN solution throws an ugly warning when reading json from postgres:\r\n\" RS-DBI driver warning: (unrecognized PostgreSQL field type json \". Probably, that's rather an DBI problem, but I would be great if this new R Postgre package would resolve the issue somehow. Particularly because the current workaround to avoid the warning is to cast json to text in SQL, but might be more difficult (slower) with the new jsonb stuff.   "},"comment":{"url":"https://api.github.com/repos/rstats-db/RPostgres/issues/comments/76629229","html_url":"https://github.com/rstats-db/RPostgres/issues/18#issuecomment-76629229","issue_url":"https://api.github.com/repos/rstats-db/RPostgres/issues/18","id":76629229,"user":{"login":"hadley","id":4196,"avatar_url":"https://avatars.githubusercontent.com/u/4196?v=3","gravatar_id":"","url":"https://api.github.com/users/hadley","html_url":"https://github.com/hadley","followers_url":"https://api.github.com/users/hadley/followers","following_url":"https://api.github.com/users/hadley/following{/other_user}","gists_url":"https://api.github.com/users/hadley/gists{/gist_id}","starred_url":"https://api.github.com/users/hadley/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/hadley/subscriptions","organizations_url":"https://api.github.com/users/hadley/orgs","repos_url":"https://api.github.com/users/hadley/repos","events_url":"https://api.github.com/users/hadley/events{/privacy}","received_events_url":"https://api.github.com/users/hadley/received_events","type":"User","site_admin":false},"created_at":"2015-03-01T20:39:15Z","updated_at":"2015-03-01T20:39:15Z","body":"Perhaps you could create such a database with SQL code... I have limited capability to learn Postgres specific SQL so if you want me to look into this more, you'll need to include a basic example. "}}