Delete database

• https://www.postgresql.org/docs/current/sql-dropdatabase.html

PostgreSQL

DROP DATABASE [IF EXISTS] my_database_name;

Do not forget the ; at the end of the line

DROP DATABASE [IF EXISTS] my_database_name (FORCE) ;
Note: FORCE introduced in 2022 (PostgreSQL 13)

DROP DATABASE database_name;
Output:
DROP DATABASE

DROP DATABASE database_name (FORCE);

ERROR: database "XXXXX" is being accessed by other users
DETAIL: There are 4 other sessions using the database

Related terms:

• sudo -u postgres psql
• community.postgresql.postgresql_db_module: state: absent

Related

• DELETE
• DROP TABLE
• CREATE DATABASE
• \list
• PostgreSQL superuser
• ALTER DATABASE
• ERROR: must be owner of database

• GRANT "your-defined role" TO "your username";

See also

• DROP, DROP DATABASE, DROP TABLE, dropdb
• Show databases, Create database, Delete database, GRANT, DROP DATABASE
• PostgreSQL: Database roles, CREATE USER, CREATE ROLE, \du, \du+, create user, Alter user