Parent Directory | Revision Log
you can specify database name
1 | dpavlin | 89 | #!/bin/sh |
2 | |||
3 | # count number of records in all tables | ||
4 | |||
5 | dpavlin | 116 | if [ -z "$1" ] ; then |
6 | db="webpac-dev" | ||
7 | else | ||
8 | db=$1 | ||
9 | fi | ||
10 | dpavlin | 89 | |
11 | echo "records in $db, by table" | ||
12 | 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.2 |
svn:executable | * |
ViewVC Help | |
Powered by ViewVC 1.1.26 |