Parent Directory | Revision Log
count number of entries in tables (one for each index)
1 | dpavlin | 89 | #!/bin/sh |
2 | |||
3 | # count number of records in all tables | ||
4 | |||
5 | db="webpac-dev" | ||
6 | |||
7 | echo "records in $db, by table" | ||
8 | psql $db -A -t -F : -c "\d" | cut -d: -f2 | xargs -i psql $db -A -t -F " " -c "select count(*),'{}' from {}" | sort -nr |
Name | Value |
---|---|
cvs2svn:cvs-rev | 1.1 |
svn:executable | * |
ViewVC Help | |
Powered by ViewVC 1.1.26 |