Cannot drop database in postgres I would like to unserstand why I am not able to drop a database from cmd:
I execute the command: drop database if exists &lt;db_name&gt; but the result is as below:
postgres=# drop database testV5;

ERROR:  database &quot;testV5&quot; does not exist

knowing that the database exists:
postgres=# \l
                                  Liste des bases de donnÚes


   Nom     | PropriÚtaire | Encodage |  Collationnement   |    Type caract.    |    Droits d'accÞs
  testV4   | postgres     | UTF8     | French_Canada.1252 | French_Canada.1252 |
  testV5   | postgres     | UTF8     | French_Canada.1252 | French_Canada.1252 |
  postgres | postgres     | UTF8     | French_Canada.1252 | French_Canada.1252 |
  template0| postgres     | UTF8     | French_Canada.1252 | French_Canada.1252 |          
  template1| postgres     | UTF8     | French_Canada.1252 | French_Canada.1252 |         
    

Can anyone explain that please ?
Thanks in advance.
You created the database with double quotes, so the name is case sensitive now. You need to use the dreaded double quotes when dropping the database as well:
drop database &quot;testV5&quot;;


Note that using quoted identifiers is discouraged