--- trunk/tools/count_tables.sh 2003/07/21 15:54:57 116 +++ trunk/tools/count_tables.sh 2003/07/21 16:05:42 117 @@ -9,4 +9,4 @@ fi echo "records in $db, by table" -psql $db -A -t -F : -c "\d" | cut -d: -f2 | xargs -i psql $db -A -t -F " " -c "select count(*),'{}' from {}" | sort -nr +psql $db -A -t -c "select tablename from pg_tables where tablename not like 'pg_%'" | xargs -i psql $db -A -t -F " " -c "select count(*),'{}' from {}" | sort -nr