dropdb [ ''options''...? dbname
-h, --host host
Specifies the host name of the machine on which the server is running. If host begins with a slash, it is used as the directory for the Unix domain socket.
-p, --port port
Specifies the Internet TCP/IP port or local Unix domain socket file extension on which the server is listening for connections.
-U, --username username
User name to connect as
Force password prompt.
Echo the queries that dropdb generates and sends to the server.
Do not display a response.
Issues a verification prompt before doing anything destructive.
Specifies the name of the database to be removed. The database must be one of the existing PostgreSQL databases in this installation.
The options -h, -p, -U, -W, and -e are passed on literally to psql(1).
The database was successfully removed.
dropdb: Database removal failed.
Something didn't work out.
dropdb destroys an existing PostgreSQL database. The user who executes this command must be a database superuser or the owner of the database.
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 query: