{"action":"created","issue":{"url":"https://api.github.com/repos/amjith/pgcli/issues/166","labels_url":"https://api.github.com/repos/amjith/pgcli/issues/166/labels{/name}","comments_url":"https://api.github.com/repos/amjith/pgcli/issues/166/comments","events_url":"https://api.github.com/repos/amjith/pgcli/issues/166/events","html_url":"https://github.com/amjith/pgcli/issues/166","id":59475428,"number":166,"title":"Table header shows \"?column?\" as column name","user":{"login":"wbolster","id":748944,"avatar_url":"https://avatars.githubusercontent.com/u/748944?v=3","gravatar_id":"","url":"https://api.github.com/users/wbolster","html_url":"https://github.com/wbolster","followers_url":"https://api.github.com/users/wbolster/followers","following_url":"https://api.github.com/users/wbolster/following{/other_user}","gists_url":"https://api.github.com/users/wbolster/gists{/gist_id}","starred_url":"https://api.github.com/users/wbolster/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/wbolster/subscriptions","organizations_url":"https://api.github.com/users/wbolster/orgs","repos_url":"https://api.github.com/users/wbolster/repos","events_url":"https://api.github.com/users/wbolster/events{/privacy}","received_events_url":"https://api.github.com/users/wbolster/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2015-03-02T12:32:45Z","updated_at":"2015-03-02T16:05:49Z","closed_at":"2015-03-02T16:05:49Z","body":"This query:\r\n\r\n```sql\r\nSELECT jsonb_column->>'field' FROM tbl;\r\n```\r\n\r\n...results in an output table with a column named `?column?`. Is this intended?\r\n\r\nFor comparison, the query:\r\n\r\n```sql\r\nSELECT jsonb_column->>'field' AS \"title\" FROM tbl;\r\n```\r\n\r\n... shows `title` as the column title."},"comment":{"url":"https://api.github.com/repos/amjith/pgcli/issues/comments/76739501","html_url":"https://github.com/amjith/pgcli/issues/166#issuecomment-76739501","issue_url":"https://api.github.com/repos/amjith/pgcli/issues/166","id":76739501,"user":{"login":"wbolster","id":748944,"avatar_url":"https://avatars.githubusercontent.com/u/748944?v=3","gravatar_id":"","url":"https://api.github.com/users/wbolster","html_url":"https://github.com/wbolster","followers_url":"https://api.github.com/users/wbolster/followers","following_url":"https://api.github.com/users/wbolster/following{/other_user}","gists_url":"https://api.github.com/users/wbolster/gists{/gist_id}","starred_url":"https://api.github.com/users/wbolster/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/wbolster/subscriptions","organizations_url":"https://api.github.com/users/wbolster/orgs","repos_url":"https://api.github.com/users/wbolster/repos","events_url":"https://api.github.com/users/wbolster/events{/privacy}","received_events_url":"https://api.github.com/users/wbolster/received_events","type":"User","site_admin":false},"created_at":"2015-03-02T16:05:49Z","updated_at":"2015-03-02T16:05:49Z","body":"Ah, didn't know this was a PostgreSQL thing; I assumed it was some missing formatting stuff on the `pgcli` side. Nevermind, closing."}}