Skip to content

Instantly share code, notes, and snippets.

@etozzato
Last active August 29, 2015 14:07
Show Gist options
  • Save etozzato/1d602cef0c3b3b27eb8c to your computer and use it in GitHub Desktop.
Save etozzato/1d602cef0c3b3b27eb8c to your computer and use it in GitHub Desktop.
for TABLE in $(psql table_name -c "\dt" | awk '{print $3}'); do psql table_name -c "select '$TABLE', count(*) from $TABLE;" | grep -A1 "\-\-\-\-" | tail -1; done
active_admin_comments | 1
admin_users | 2
agents | 3
clients | 398
dispensaries | 21
edu_pages | 22
foreign_ids | 29
images | 0
lab_results | 2872
lab_test_types | 9
lab_tests | 3074
mercury_images | 0
orders | 981
pages | 12
payments | 978
products | 1894
schema_migrations | 39
skus | 43
strain_details | 0
testimonials | 12
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment