diff options
| author | Bruce Momjian | 1999-12-04 04:53:22 +0000 |
|---|---|---|
| committer | Bruce Momjian | 1999-12-04 04:53:22 +0000 |
| commit | 240e4c98f5f41d83d3c887d26e2dbfd9bd849d00 (patch) | |
| tree | 490d2b494601e7b36167dc997908ffeaf92567f3 /src/bin/scripts/dropdb | |
| parent | 21b69148dce2a7d178d1c4cd060a1ed06fe7b3b4 (diff) | |
New scripts for create/drop user/db from Peter Eisentraut
Diffstat (limited to 'src/bin/scripts/dropdb')
| -rw-r--r-- | src/bin/scripts/dropdb | 92 |
1 files changed, 92 insertions, 0 deletions
diff --git a/src/bin/scripts/dropdb b/src/bin/scripts/dropdb new file mode 100644 index 00000000000..96a0a10cb62 --- /dev/null +++ b/src/bin/scripts/dropdb @@ -0,0 +1,92 @@ +#!/bin/sh +#------------------------------------------------------------------------- +# +# dropdb-- +# destroy a postgres database +# +# this program runs psql to drop the requested database. +# +# Copyright (c) 1994, Regents of the University of California +# +# +# IDENTIFICATION +# $Header: /cvsroot/pgsql/src/bin/scripts/Attic/dropdb,v 1.1 1999/12/04 04:53:21 momjian Exp $ +# +#------------------------------------------------------------------------- + +CMDNAME=`basename $0` + +PSQLOPT= +dbname= +forcedel=t + +while [ $# -gt 0 ] +do + case "$1" in + --help|-\?) + usage=t + break + ;; +# options passed on to psql + --host|-h) + PSQLOPT="$PSQLOPT -h $2" + shift;; + --port|-p) + PSQLOPT="$PSQLOPT -p $2" + shift;; + --user|--username|-U) + PSQLOPT="$PSQLOPT -U $2" + shift;; + --password|-W) + PSQLOPT="$PSQLOPT -W" + ;; + --echo|-e) + PSQLOPT="$PSQLOPT -e" + ;; + --quiet|-q) + PSQLOPT="$PSQLOPT -o /dev/null" + ;; +# other options + --interactive|-i) + forcedel=f + ;; + -*) + echo "$CMDNAME: Unrecognized option: $1. Try -? for help." + exit 1 + ;; + *) + dbname="$1" + ;; + esac + shift +done + + +if [ "$usage" ]; then + echo "Usage: $CMDNAME [-h <server>] [-p <port>] [-U <username>] [-W] [-i] dbname" + exit 0 +fi + +if [ -z "$dbname" ]; then + echo "$CMDNAME: Missing required argument database name. Try -? for help." + exit 1 +fi + + +if [ "$forcedel" = f ]; then + echo "Database \"$dbname\" will be permanently deleted." + echo -n "Are you sure? (y/n) " + read -r + + [ $? -eq 1 ] && exit 1 + [ "$REPLY" != "y" -a "$REPLY" != "Y" ] && exit 0 +fi + + +psql $PSQLOPT -d template1 -c "DROP DATABASE \"$dbname\"" +if [ $? -ne 0 ]; then + echo "$CMDNAME: Database removal failed." + exit 1 +fi + +exit 0
\ No newline at end of file |