If you are the owner of the database mydb, you can destroy it using the SQL command
=> DROP DATABASE mydb;
or the Unix shell script
% dropdb mydb
This 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.