1111#
1212#
1313# IDENTIFICATION
14- # $Header: /cvsroot/pgsql/src/bin/scripts/Attic/vacuumdb,v 1.6 1999/12/18 08:39:12 momjian Exp $
14+ # $Header: /cvsroot/pgsql/src/bin/scripts/Attic/vacuumdb,v 1.7 1999/12/18 08:46:44 momjian Exp $
1515#
1616# -------------------------------------------------------------------------
1717
@@ -22,6 +22,7 @@ verbose=
2222analyze=
2323table=
2424dbname=
25+ alldb=
2526
2627while [$# -gt 0 ]
2728do
8687analyze=" ANALYZE"
8788;;
8889--alldb|-a)
89- dbname= " ` psql $PASSWDOPT $AUTHOPT $PGHOSTOPT $PGPORTOPT -q -t -A -d template1 -c ' SELECT datname FROM pg_database ' ` "
90+ alldb=Y
9091;;
9192--table|-t)
9293table=" $2 "
@@ -132,6 +133,10 @@ if [ "$usage" ]; then
132133exit 1
133134fi
134135
136+ if [! -z " $alldb " ; then
137+ dbname=" ` psql$PASSWDOPT $AUTHOPT $PGHOSTOPT $PGPORTOPT -q -t -A -d template1 -c' SELECT datname FROM pg_database' ` "
138+ fi
139+
135140if [-z " $dbname " ; then
136141echo " $CMDNAME : Missing required argument database name. Try -? for help."
137142exit 1