Unsupported versions: 7.2 / 7.1

Historical version. PostgreSQL 7.2 has reached end of support. See the current manual.

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.

Report a documentation issue

Read the upstream documentation. For corrections, first check the current manual.