Unsupported versions: 7.2 / 7.1
This documentation is for an unsupported version of PostgreSQL.
You may want to view the same page for the current version, or one of the other supported versions listed above instead.

10.3. Destroying a Database

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.