This page in other versions: Unsupported versions: 7.0

Destroying a Database

If you are the database administrator for the database mydb, you can destroy it using the following Unix command:

% dropdb dbname
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.

It is also possible to destroy a database from within an SQL session by using

> drop database dbname
Privacy Policy | About PostgreSQL
Copyright © 1996-2018 The PostgreSQL Global Development Group