Home > Net >  not able to delete database in postgres
not able to delete database in postgres

Time:08-08

enter image description here

The drop database command is not working in sql shell. It shows db doesn't exists. But pgadmin and \l shows the db. What is the problem and how to delete the db?

CodePudding user response:

Try writing "myDatabase" (with quotation marks "") since your name is case-sensitive. In general it is better to use lower-case names in postgres and I think in unix in general.

  • Related