dropdb(1)

DROPDB(1)        PostgreSQL Client Applications         DROPDB(1)

NAME

     dropdb - remove a PostgreSQL database

SYNOPSIS

     dropdb [ option... ]  dbname

DESCRIPTION

     dropdb destroys an existing PostgreSQL database.   The  user
     who  executes  this  command must be a database superuser or
     the owner of the database.

     dropdb is a wrapper around the  SQL  command  DROP  DATABASE
     [drop_database(5)].    There   is  no  effective  difference
     between dropping databases via this utility  and  via  other
     methods for accessing the server.

OPTIONS

     dropdb accepts the following command-line arguments:

     dbname
          Specifies the name of the database to be removed.

     -e

     --echo
          Echo the commands that dropdb generates  and  sends  to
          the server.

     -i

     --interactive
          Issues a verification prompt before doing anything des-
          tructive.

     -q

     --quiet
          Do not display a response.

     dropdb also accepts the following command-line arguments for
     connection parameters:

     -h host

     --host host
          Specifies the host name of the  machine  on  which  the
          server is running. If the value begins with a slash, it
          is used as the directory for the Unix domain socket.

     -p port

Application          Last change: 2008-01-03                    1

DROPDB(1)        PostgreSQL Client Applications         DROPDB(1)

     --port port
          Specifies the TCP port or local Unix domain socket file
          extension  on which the server is listening for connec-
          tions.

     -U username

     --username username
          User name to connect as

     -W

     --password
          Force password prompt.

ENVIRONMENT

     PGHOST

     PGPORT

     PGUSER
          Default connection parameters

     This utility, like most  other  PostgreSQL  utilities,  also
     uses  the  environment  variables supported by libpq (see in
     the documentation).

DIAGNOSTICS

     In case of difficulty, see DROP DATABASE  [drop_database(5)]
     and  psql(1) for discussions of potential problems and error
     messages.  The database server must be running at  the  tar-
     geted  host.  Also,  any  default  connection  settings  and
     environment variables used by the  libpq  front-end  library
     will apply.

EXAMPLES

     To destroy the database demo on the default database server:

     $ dropdb demo
     DROP DATABASE

     To destroy the database demo using the server on host  eden,
     port  5000,  with  verification and a peek at the underlying
     command:

     $ dropdb -p 5000 -h eden -i -e demo
     Database "demo" will be permanently deleted.
     Are you sure? (y/n) y
     DROP DATABASE "demo"
     DROP DATABASE

Application          Last change: 2008-01-03                    2

DROPDB(1)        PostgreSQL Client Applications         DROPDB(1)

SEE ALSO

     createdb(1), DROP DATABASE [drop_database(5)]

Application          Last change: 2008-01-03                    3