cannot drop database in postgres using terminal

Question

I created a database with the name "femme-myp " in postgres. There was no problem while creation or while using tables in python Django. but when i try to drop the database in terminal it says there is an error in the name and it points at the "-" in the name.Is there any way I can drop that database?

ERROR:  syntax error at or near "-"
LINE 1: DROP DATABASE femme-myp;
                           ^

dassum · Accepted Answer · 2019-10-03 16:36:38Z

3

try with quotes in the database name:

DROP DATABASE "femme-myp";

All identifiers that don't start with a letter and contain characters other than letters, digits and the underscore _ must be quoted.

edited Oct 3, 2019 at 16:36

answered Oct 3, 2019 at 12:45

dassum

5,1422 gold badges30 silver badges40 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

cannot drop database in postgres using terminal

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related