23.5. Destroying a Database
DROP DATABASE name;
Only the owner of the database, or a superuser, can drop a database. Dropping a database removes all objects that were contained within the database. The destruction of a database cannot be undone.
You cannot execute the
DROP DATABASEcommand while connected to the victim database. You can, however, be connected to any other database, including the
template1would be the only option for dropping the last user database of a given cluster.
createdb, it is not the default action to drop the database with the current user name.)\