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.