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

General view of the command
DROP DATABASE [ IF EXISTS ] name [ [ WITH ] ( option [, ...] ) ]
Arguments
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

Examples

DROP DATABASE [IF EXISTS] db_name;
Found a mistake? Seleсt text and press Ctrl+Enter to report it