dropdb

Contents

dropdb [<connection-option> ...] [-e] [-i] <dbname>

dropdb -? | --help

dropdb -V | --version

Description

dropdb destroys an existing database. The user who runs this command must be a superuser or the owner of the database being dropped.

dropdb is a wrapper around the SQL command DROP DATABASE.

<dbname>: The name of the database to be removed.
-e | --echo: Echo the commands that dropdb generates and sends to the server.
-i | --interactive: Issue a verification prompt before doing anything destructive.
-V | --version: Print the dropdb version and exit.
--if-exists: Do not throw an error if the database does not exist. A notice is issued in this case.
-? | --help: Show help about dropdb command line arguments, and exit.

-h <host> | --host=<host>: The host name of the machine on which the Greengage DB master is running. If not specified, reads from the PGHOST environment variable or defaults to localhost.
-p <port> | --port=<port>: The TCP port on which the Greengage DB master is listening for connections. If not specified, reads from the PGPORT environment variable or defaults to 5432.
-U <username> | --username=<username>: The database role name to connect as. If not specified, reads from the PGUSER environment variable or defaults to the current system role name.
-w | --no-password: Never issue a password prompt. If the server requires password authentication and a password is not available by other means such as a .pgpass file, the connection attempt will fail. This option can be useful in batch jobs and scripts where no user is present to enter a password.
-W | --password: Force a password prompt.
--maintenance-db=<dbname>: The name of the database to connect to in order to drop the target database. If not specified, the postgres database will be used; if that does not exist (or if it is the name of the database being dropped), template1 will be used.

Destroy the demo database using default connection parameters:
```
$ dropdb demo
```

Destroy the demo database using connection options, with verification, and echo the generated SQL command:

$ dropdb -p 54321 -h mdw -i -e demo

The prompt:

Database "demo" will be permanently deleted.
Are you sure? (y/n) y

The result:

DROP DATABASE "demo"
DROP DATABASE