Created
November 7, 2012 20:47
-
-
Save zhm/4034326 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
select | |
(select count(1) from acls) as acls, | |
(select count(1) from changeset_tags) as changeset_tags, | |
(select count(1) from changesets) as changesets, | |
(select count(1) from client_applications) as client_applications, | |
(select count(1) from countries) as countries, | |
(select count(1) from current_node_tags) as current_node_tags, | |
(select count(1) from current_nodes) as current_nodes, | |
(select count(1) from current_relation_members) as current_relation_members, | |
(select count(1) from current_relation_tags) as current_relation_tags, | |
(select count(1) from current_relations) as current_relations, | |
(select count(1) from current_way_nodes) as current_way_nodes, | |
(select count(1) from current_way_tags) as current_way_tags, | |
(select count(1) from current_ways) as current_ways, | |
(select count(1) from diary_comments) as diary_comments, | |
(select count(1) from diary_entries) as diary_entries, | |
(select count(1) from friends) as friends, | |
(select count(1) from gps_points) as gps_points, | |
(select count(1) from gpx_file_tags) as gpx_file_tags, | |
(select count(1) from gpx_files) as gpx_files, | |
(select count(1) from languages) as languages, | |
(select count(1) from messages) as messages, | |
(select count(1) from node_tags) as node_tags, | |
(select count(1) from nodes) as nodes, | |
(select count(1) from oauth_nonces) as oauth_nonces, | |
(select count(1) from oauth_tokens) as oauth_tokens, | |
(select count(1) from relation_members) as relation_members, | |
(select count(1) from relation_tags) as relation_tags, | |
(select count(1) from relations) as relations, | |
(select count(1) from schema_migrations) as schema_migrations, | |
(select count(1) from sessions) as sessions, | |
(select count(1) from spatial_ref_sys) as spatial_ref_sys, | |
(select count(1) from user_blocks) as user_blocks, | |
(select count(1) from user_preferences) as user_preferences, | |
(select count(1) from user_roles) as user_roles, | |
(select count(1) from user_tokens) as user_tokens, | |
(select count(1) from users) as users, | |
(select count(1) from way_nodes) as way_nodes, | |
(select count(1) from way_tags) as way_tags, | |
(select count(1) from ways) as ways |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment