When you drop a database PostgreSQL will remove the physical files used for storing the database. This is an irreversible operation. Drops all tables in the database and deletes the database.If you have access to a database with the same name as the one you are trying to delete and you want to keep that database you must first delete or rename it.The PostgreSQL DROP DATABASE statement is used to remove a database from the system. It cannot be executed while you are connected to the target database. The owner of the database can execute this statement.This statement will delete the catalog entries for the database and all its tables user-defined functions views and sequences. However it will not delete the actual data files used by the database.PostgreSQL DROP/Delete DATABASE is a command used to remove a database from the system. If you drop a database all the tables in the database will be deleted and you will no longer be able to access any data stored in those tables. Therefore it is important to be sure that you really want to delete the database before using this command.