If you are the owner of the database mydb, you can destroy it using the following Unix command:
% dropdb mydbThis action physically removes all of the Unix files associated with the database and cannot be undone, so this should only be done with a great deal of forethought.
Read the upstream documentation. For corrections, first check the current manual.