diff options
Diffstat (limited to 'src/bin/scripts/dropdb')
| -rw-r--r-- | src/bin/scripts/dropdb | 30 |
1 files changed, 27 insertions, 3 deletions
diff --git a/src/bin/scripts/dropdb b/src/bin/scripts/dropdb index 93727fd252..8ef22fce84 100644 --- a/src/bin/scripts/dropdb +++ b/src/bin/scripts/dropdb @@ -10,7 +10,7 @@ # # # IDENTIFICATION -# $Header: /cvsroot/pgsql/src/bin/scripts/Attic/dropdb,v 1.2 1999/12/05 20:52:54 momjian Exp $ +# $Header: /cvsroot/pgsql/src/bin/scripts/Attic/dropdb,v 1.3 1999/12/07 22:41:44 momjian Exp $ # #------------------------------------------------------------------------- @@ -31,6 +31,7 @@ else ECHO_C='\c' fi + while [ $# -gt 0 ] do case "$1" in @@ -42,12 +43,33 @@ do --host|-h) PSQLOPT="$PSQLOPT -h $2" shift;; + -h*) + PSQLOPT="$PSQLOPT $1" + ;; + --host=*) + PSQLOPT="$PSQLOPT -h "`echo $1 | sed 's/^--host=//'` + ;; --port|-p) PSQLOPT="$PSQLOPT -p $2" shift;; + -p*) + PSQLOPT="$PSQLOPT $1" + ;; + --port=*) + PSQLOPT="$PSQLOPT -p "`echo $1 | sed 's/^--port=//'` + ;; --user|--username|-U) - PSQLOPT="$PSQLOPT -U $2" + PSQLOPT="$PSQLOPT -U '$2'" shift;; + -U*) + PSQLOPT="$PSQLOPT $1" + ;; + --user=*) + PSQLOPT="$PSQLOPT -U "`echo $1 | sed 's/^--user=//'` + ;; + --username=*) + PSQLOPT="$PSQLOPT -U "`echo $1 | sed 's/^--username=//'` + ;; --password|-W) PSQLOPT="$PSQLOPT -W" ;; @@ -74,7 +96,7 @@ done if [ "$usage" ]; then - echo "Usage: $CMDNAME [-h <server>] [-p <port>] [-U <username>] [-W] [-i] dbname" + echo "Usage: $CMDNAME [-h server] [-p port] [-U username] [-i] dbname" exit 0 fi @@ -94,6 +116,8 @@ if [ "$forcedel" = f ]; then fi +dbname=`echo $dbname | sed 's/\"/\\\"/g'` + psql $PSQLOPT -d template1 -c "DROP DATABASE \"$dbname\"" if [ $? -ne 0 ]; then echo "$CMDNAME: Database removal failed." |