DROP DATABASE
The DROP DATABASE command removes a database. You can find the full description of this command on the official docs page.
Description
This command removes the catalog entries for the database and deletes the directory containing the data. It can only be executed by the database owner. It cannot be executed while you are connected to the target database. (Connect to postgres or any other database to issue this command.) Also, if anyone else is connected to the target database, this command will fail unless you use the FORCE option described below.
|
IMPORTANT
DROP DATABASE cannot be undone. Use it with care!
|
Usage
DROP DATABASE [ IF EXISTS ] name [ [ WITH ] ( option [, ...] ) ]| Parameter | Description |
|---|---|
IF EXISTS |
Do not throw an error if the database does not exist. A notice is issued in this case |
name |
The name of the database to remove |
FORCE |
Attempt to terminate all existing connections to the target database. The connections are not terminated if prepared transactions, active logical replication slots or subscriptions are present in the target database |