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) ;

DROP DATABASE database_name;
Output:
DROP DATABASE

DROP DATABASE database_name (FORCE);

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