This is repository of my old source code which isn't updated any more. Go to git.rot13.org for current projects!
ViewVC logotype

Contents of /trunk/tools/count_tables.sh

Parent Directory Parent Directory | Revision Log Revision Log

Revision 89 - (show annotations)
Sun Jul 13 12:24:06 2003 UTC (17 years ago) by dpavlin
File MIME type: application/x-sh
File size: 221 byte(s)
count number of entries in tables (one for each index)

1 #!/bin/sh
3 # count number of records in all tables
5 db="webpac-dev"
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