DROPDB(1) PostgreSQL Client Applications DROPDB(1)NAMEdropdb - remove a PostgreSQL database
SYNOPSISdropdb [ option... ] dbname
DESCRIPTIONdropdb 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_data-
base(5)]. There is no effective difference between dropping databases
via this utility and via other methods for accessing the server.
OPTIONSdropdb 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 destructive.
-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
--port port
Specifies the TCP port or local Unix domain socket file exten-
sion on which the server is listening for connections.
-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 envi-
ronment 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 targeted host. Also, any default connec-
tion 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
SEE ALSOcreatedb(1), DROP DATABASE [drop_database(5)]
Application 2008-06-08 DROPDB(1)
