dropdb

where:

destroys an existing database. The user who executes 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 generates and sends to the server.

-i, —interactive

<connection_options>

-h, —host <host>

The host name of the machine on which the HAWQ master database server is running. If not specified, reads from the environment variable PGHOST or defaults to localhost.

-p, —port <port>

The TCP port on which the HAWQ master database server is listening for connections. If not specified, reads from the environment variable PGPORT or defaults to 5432.

-U, —username <username>

The database role name to connect as. If not specified, reads from the environment variable or defaults to the current system role name.

-w, —no-password

-W, —password

Force a password prompt.

Other Options

--help

Displays the online help.

--version

Displays the version of this utility.

To destroy the database named demo using default connection parameters: