Normally to drop a database in PostgreSQL, we can just type:

DROP DATABASE database;

Here’s a list of my current databases:

And I want to drop a database called “postgres-db”. So, let’s try:

According to this, we have to escape the database name which contains a dash or hyphen in double quotation marks:

It works.