{"action":"created","comment":{"url":"https://api.github.com/repos/cockroachdb/docs/pulls/comments/93516713","pull_request_review_id":14046377,"id":93516713,"diff_hunk":"@@ -49,6 +49,7 @@ Statement | Usage\n [`SHOW TABLES`](show-tables.html) | List tables in a database.\n [`SHOW TIME ZONE`](show-time-zone.html) | View the default time zone for the session.\n [`SHOW TRANSACTION`](show-transaction.html) | View the isolation level or priority for the session or for an individual [transaction](transactions.html).\n+[`SHOW USERS`](show-users.html) | List lists the users for all databases.","path":"sql-statements.md","position":4,"original_position":4,"commit_id":"26679c2ec35bc469b63a1d3adf99ca75fa25ff0d","original_commit_id":"7320d48ef4863870417032b9f6d71a2030a45a82","user":{"login":"jseldess","id":15893490,"avatar_url":"https://avatars.githubusercontent.com/u/15893490?v=3","gravatar_id":"","url":"https://api.github.com/users/jseldess","html_url":"https://github.com/jseldess","followers_url":"https://api.github.com/users/jseldess/followers","following_url":"https://api.github.com/users/jseldess/following{/other_user}","gists_url":"https://api.github.com/users/jseldess/gists{/gist_id}","starred_url":"https://api.github.com/users/jseldess/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jseldess/subscriptions","organizations_url":"https://api.github.com/users/jseldess/orgs","repos_url":"https://api.github.com/users/jseldess/repos","events_url":"https://api.github.com/users/jseldess/events{/privacy}","received_events_url":"https://api.github.com/users/jseldess/received_events","type":"User","site_admin":false},"body":"Need to cut \"lists\".","created_at":"2016-12-21T20:48:28Z","updated_at":"2016-12-21T20:55:06Z","html_url":"https://github.com/cockroachdb/docs/pull/939#discussion_r93516713","pull_request_url":"https://api.github.com/repos/cockroachdb/docs/pulls/939","_links":{"self":{"href":"https://api.github.com/repos/cockroachdb/docs/pulls/comments/93516713"},"html":{"href":"https://github.com/cockroachdb/docs/pull/939#discussion_r93516713"},"pull_request":{"href":"https://api.github.com/repos/cockroachdb/docs/pulls/939"}}},"pull_request":{"url":"https://api.github.com/repos/cockroachdb/docs/pulls/939","id":98999628,"html_url":"https://github.com/cockroachdb/docs/pull/939","diff_url":"https://github.com/cockroachdb/docs/pull/939.diff","patch_url":"https://github.com/cockroachdb/docs/pull/939.patch","issue_url":"https://api.github.com/repos/cockroachdb/docs/issues/939","number":939,"state":"open","locked":false,"title":"SHOW USERS statement","user":{"login":"sploiselle","id":19260003,"avatar_url":"https://avatars.githubusercontent.com/u/19260003?v=3","gravatar_id":"","url":"https://api.github.com/users/sploiselle","html_url":"https://github.com/sploiselle","followers_url":"https://api.github.com/users/sploiselle/followers","following_url":"https://api.github.com/users/sploiselle/following{/other_user}","gists_url":"https://api.github.com/users/sploiselle/gists{/gist_id}","starred_url":"https://api.github.com/users/sploiselle/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sploiselle/subscriptions","organizations_url":"https://api.github.com/users/sploiselle/orgs","repos_url":"https://api.github.com/users/sploiselle/repos","events_url":"https://api.github.com/users/sploiselle/events{/privacy}","received_events_url":"https://api.github.com/users/sploiselle/received_events","type":"User","site_admin":false},"body":"Closes #822\n\n<!-- Reviewable:start -->\n---\nThis change is [<img src=\"https://reviewable.io/review_button.svg\" height=\"34\" align=\"absmiddle\" alt=\"Reviewable\"/>](https://reviewable.io/reviews/cockroachdb/docs/939)\n<!-- Reviewable:end -->\n","created_at":"2016-12-21T20:30:29Z","updated_at":"2016-12-21T20:55:06Z","closed_at":null,"merged_at":null,"merge_commit_sha":"8f0af5d689c06cb2c8d8bc21cdeddd65fca1c265","assignee":null,"assignees":[],"milestone":null,"commits_url":"https://api.github.com/repos/cockroachdb/docs/pulls/939/commits","review_comments_url":"https://api.github.com/repos/cockroachdb/docs/pulls/939/comments","review_comment_url":"https://api.github.com/repos/cockroachdb/docs/pulls/comments{/number}","comments_url":"https://api.github.com/repos/cockroachdb/docs/issues/939/comments","statuses_url":"https://api.github.com/repos/cockroachdb/docs/statuses/26679c2ec35bc469b63a1d3adf99ca75fa25ff0d","head":{"label":"cockroachdb:show-users","ref":"show-users","sha":"26679c2ec35bc469b63a1d3adf99ca75fa25ff0d","user":{"login":"cockroachdb","id":6748139,"avatar_url":"https://avatars.githubusercontent.com/u/6748139?v=3","gravatar_id":"","url":"https://api.github.com/users/cockroachdb","html_url":"https://github.com/cockroachdb","followers_url":"https://api.github.com/users/cockroachdb/followers","following_url":"https://api.github.com/users/cockroachdb/following{/other_user}","gists_url":"https://api.github.com/users/cockroachdb/gists{/gist_id}","starred_url":"https://api.github.com/users/cockroachdb/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cockroachdb/subscriptions","organizations_url":"https://api.github.com/users/cockroachdb/orgs","repos_url":"https://api.github.com/users/cockroachdb/repos","events_url":"https://api.github.com/users/cockroachdb/events{/privacy}","received_events_url":"https://api.github.com/users/cockroachdb/received_events","type":"Organization","site_admin":false},"repo":{"id":48004987,"name":"docs","full_name":"cockroachdb/docs","owner":{"login":"cockroachdb","id":6748139,"avatar_url":"https://avatars.githubusercontent.com/u/6748139?v=3","gravatar_id":"","url":"https://api.github.com/users/cockroachdb","html_url":"https://github.com/cockroachdb","followers_url":"https://api.github.com/users/cockroachdb/followers","following_url":"https://api.github.com/users/cockroachdb/following{/other_user}","gists_url":"https://api.github.com/users/cockroachdb/gists{/gist_id}","starred_url":"https://api.github.com/users/cockroachdb/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cockroachdb/subscriptions","organizations_url":"https://api.github.com/users/cockroachdb/orgs","repos_url":"https://api.github.com/users/cockroachdb/repos","events_url":"https://api.github.com/users/cockroachdb/events{/privacy}","received_events_url":"https://api.github.com/users/cockroachdb/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/cockroachdb/docs","description":"CockroachDB user documentation","fork":false,"url":"https://api.github.com/repos/cockroachdb/docs","forks_url":"https://api.github.com/repos/cockroachdb/docs/forks","keys_url":"https://api.github.com/repos/cockroachdb/docs/keys{/key_id}","collaborators_url":"https://api.github.com/repos/cockroachdb/docs/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/cockroachdb/docs/teams","hooks_url":"https://api.github.com/repos/cockroachdb/docs/hooks","issue_events_url":"https://api.github.com/repos/cockroachdb/docs/issues/events{/number}","events_url":"https://api.github.com/repos/cockroachdb/docs/events","assignees_url":"https://api.github.com/repos/cockroachdb/docs/assignees{/user}","branches_url":"https://api.github.com/repos/cockroachdb/docs/branches{/branch}","tags_url":"https://api.github.com/repos/cockroachdb/docs/tags","blobs_url":"https://api.github.com/repos/cockroachdb/docs/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/cockroachdb/docs/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/cockroachdb/docs/git/refs{/sha}","trees_url":"https://api.github.com/repos/cockroachdb/docs/git/trees{/sha}","statuses_url":"https://api.github.com/repos/cockroachdb/docs/statuses/{sha}","languages_url":"https://api.github.com/repos/cockroachdb/docs/languages","stargazers_url":"https://api.github.com/repos/cockroachdb/docs/stargazers","contributors_url":"https://api.github.com/repos/cockroachdb/docs/contributors","subscribers_url":"https://api.github.com/repos/cockroachdb/docs/subscribers","subscription_url":"https://api.github.com/repos/cockroachdb/docs/subscription","commits_url":"https://api.github.com/repos/cockroachdb/docs/commits{/sha}","git_commits_url":"https://api.github.com/repos/cockroachdb/docs/git/commits{/sha}","comments_url":"https://api.github.com/repos/cockroachdb/docs/comments{/number}","issue_comment_url":"https://api.github.com/repos/cockroachdb/docs/issues/comments{/number}","contents_url":"https://api.github.com/repos/cockroachdb/docs/contents/{+path}","compare_url":"https://api.github.com/repos/cockroachdb/docs/compare/{base}...{head}","merges_url":"https://api.github.com/repos/cockroachdb/docs/merges","archive_url":"https://api.github.com/repos/cockroachdb/docs/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/cockroachdb/docs/downloads","issues_url":"https://api.github.com/repos/cockroachdb/docs/issues{/number}","pulls_url":"https://api.github.com/repos/cockroachdb/docs/pulls{/number}","milestones_url":"https://api.github.com/repos/cockroachdb/docs/milestones{/number}","notifications_url":"https://api.github.com/repos/cockroachdb/docs/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/cockroachdb/docs/labels{/name}","releases_url":"https://api.github.com/repos/cockroachdb/docs/releases{/id}","deployments_url":"https://api.github.com/repos/cockroachdb/docs/deployments","created_at":"2015-12-14T22:29:27Z","updated_at":"2016-12-08T20:02:40Z","pushed_at":"2016-12-21T20:49:28Z","git_url":"git://github.com/cockroachdb/docs.git","ssh_url":"git@github.com:cockroachdb/docs.git","clone_url":"https://github.com/cockroachdb/docs.git","svn_url":"https://github.com/cockroachdb/docs","homepage":"https://cockroachlabs.com/docs/","size":52399,"stargazers_count":15,"watchers_count":15,"language":"HTML","has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":true,"forks_count":28,"mirror_url":null,"open_issues_count":149,"forks":28,"open_issues":149,"watchers":15,"default_branch":"gh-pages"}},"base":{"label":"cockroachdb:gh-pages","ref":"gh-pages","sha":"539a98a7eb3b3debf01e5af289f2d1b6ff817255","user":{"login":"cockroachdb","id":6748139,"avatar_url":"https://avatars.githubusercontent.com/u/6748139?v=3","gravatar_id":"","url":"https://api.github.com/users/cockroachdb","html_url":"https://github.com/cockroachdb","followers_url":"https://api.github.com/users/cockroachdb/followers","following_url":"https://api.github.com/users/cockroachdb/following{/other_user}","gists_url":"https://api.github.com/users/cockroachdb/gists{/gist_id}","starred_url":"https://api.github.com/users/cockroachdb/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cockroachdb/subscriptions","organizations_url":"https://api.github.com/users/cockroachdb/orgs","repos_url":"https://api.github.com/users/cockroachdb/repos","events_url":"https://api.github.com/users/cockroachdb/events{/privacy}","received_events_url":"https://api.github.com/users/cockroachdb/received_events","type":"Organization","site_admin":false},"repo":{"id":48004987,"name":"docs","full_name":"cockroachdb/docs","owner":{"login":"cockroachdb","id":6748139,"avatar_url":"https://avatars.githubusercontent.com/u/6748139?v=3","gravatar_id":"","url":"https://api.github.com/users/cockroachdb","html_url":"https://github.com/cockroachdb","followers_url":"https://api.github.com/users/cockroachdb/followers","following_url":"https://api.github.com/users/cockroachdb/following{/other_user}","gists_url":"https://api.github.com/users/cockroachdb/gists{/gist_id}","starred_url":"https://api.github.com/users/cockroachdb/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cockroachdb/subscriptions","organizations_url":"https://api.github.com/users/cockroachdb/orgs","repos_url":"https://api.github.com/users/cockroachdb/repos","events_url":"https://api.github.com/users/cockroachdb/events{/privacy}","received_events_url":"https://api.github.com/users/cockroachdb/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/cockroachdb/docs","description":"CockroachDB user documentation","fork":false,"url":"https://api.github.com/repos/cockroachdb/docs","forks_url":"https://api.github.com/repos/cockroachdb/docs/forks","keys_url":"https://api.github.com/repos/cockroachdb/docs/keys{/key_id}","collaborators_url":"https://api.github.com/repos/cockroachdb/docs/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/cockroachdb/docs/teams","hooks_url":"https://api.github.com/repos/cockroachdb/docs/hooks","issue_events_url":"https://api.github.com/repos/cockroachdb/docs/issues/events{/number}","events_url":"https://api.github.com/repos/cockroachdb/docs/events","assignees_url":"https://api.github.com/repos/cockroachdb/docs/assignees{/user}","branches_url":"https://api.github.com/repos/cockroachdb/docs/branches{/branch}","tags_url":"https://api.github.com/repos/cockroachdb/docs/tags","blobs_url":"https://api.github.com/repos/cockroachdb/docs/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/cockroachdb/docs/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/cockroachdb/docs/git/refs{/sha}","trees_url":"https://api.github.com/repos/cockroachdb/docs/git/trees{/sha}","statuses_url":"https://api.github.com/repos/cockroachdb/docs/statuses/{sha}","languages_url":"https://api.github.com/repos/cockroachdb/docs/languages","stargazers_url":"https://api.github.com/repos/cockroachdb/docs/stargazers","contributors_url":"https://api.github.com/repos/cockroachdb/docs/contributors","subscribers_url":"https://api.github.com/repos/cockroachdb/docs/subscribers","subscription_url":"https://api.github.com/repos/cockroachdb/docs/subscription","commits_url":"https://api.github.com/repos/cockroachdb/docs/commits{/sha}","git_commits_url":"https://api.github.com/repos/cockroachdb/docs/git/commits{/sha}","comments_url":"https://api.github.com/repos/cockroachdb/docs/comments{/number}","issue_comment_url":"https://api.github.com/repos/cockroachdb/docs/issues/comments{/number}","contents_url":"https://api.github.com/repos/cockroachdb/docs/contents/{+path}","compare_url":"https://api.github.com/repos/cockroachdb/docs/compare/{base}...{head}","merges_url":"https://api.github.com/repos/cockroachdb/docs/merges","archive_url":"https://api.github.com/repos/cockroachdb/docs/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/cockroachdb/docs/downloads","issues_url":"https://api.github.com/repos/cockroachdb/docs/issues{/number}","pulls_url":"https://api.github.com/repos/cockroachdb/docs/pulls{/number}","milestones_url":"https://api.github.com/repos/cockroachdb/docs/milestones{/number}","notifications_url":"https://api.github.com/repos/cockroachdb/docs/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/cockroachdb/docs/labels{/name}","releases_url":"https://api.github.com/repos/cockroachdb/docs/releases{/id}","deployments_url":"https://api.github.com/repos/cockroachdb/docs/deployments","created_at":"2015-12-14T22:29:27Z","updated_at":"2016-12-08T20:02:40Z","pushed_at":"2016-12-21T20:49:28Z","git_url":"git://github.com/cockroachdb/docs.git","ssh_url":"git@github.com:cockroachdb/docs.git","clone_url":"https://github.com/cockroachdb/docs.git","svn_url":"https://github.com/cockroachdb/docs","homepage":"https://cockroachlabs.com/docs/","size":52399,"stargazers_count":15,"watchers_count":15,"language":"HTML","has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":true,"forks_count":28,"mirror_url":null,"open_issues_count":149,"forks":28,"open_issues":149,"watchers":15,"default_branch":"gh-pages"}},"_links":{"self":{"href":"https://api.github.com/repos/cockroachdb/docs/pulls/939"},"html":{"href":"https://github.com/cockroachdb/docs/pull/939"},"issue":{"href":"https://api.github.com/repos/cockroachdb/docs/issues/939"},"comments":{"href":"https://api.github.com/repos/cockroachdb/docs/issues/939/comments"},"review_comments":{"href":"https://api.github.com/repos/cockroachdb/docs/pulls/939/comments"},"review_comment":{"href":"https://api.github.com/repos/cockroachdb/docs/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/cockroachdb/docs/pulls/939/commits"},"statuses":{"href":"https://api.github.com/repos/cockroachdb/docs/statuses/26679c2ec35bc469b63a1d3adf99ca75fa25ff0d"}}}}
{"actor":{"display_login":"jseldess"}}