DEV Community

eddiejpot
eddiejpot

Posted on

PostgreSQL: Drop a database that has a hyphen in the name

Normally to drop a database in psql (postgresql) , we can just type

DROP DATABASE dbname;
Enter fullscreen mode Exit fullscreen mode

If we want to drop a database called "db-name". we have to escape the database name which contains the hyphen by using double quotation marks.

DROP DATABASE "db-name";
Enter fullscreen mode Exit fullscreen mode

Resource link here here

Top comments (0)

Read next

keploy profile image

A Comprehensive Guide to cypress run: Automate Your Testing Workflow

keploy -

wpbones profile image

WP Bones 1.8.0: Advancing WordPress Plugin Development

wpbones -

valeriavg profile image

What would you wish for in an Advent Calendar?

Valeria -

mikeyoung44 profile image

A beginner's guide to the Qwen-7b-Chat model by Niron1 on Replicate

Mike Young -