select open change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Unsupported versions: 7.2 / 7.1
Historical version. PostgreSQL 7.2 reached end of support in February 2007. See the current manual for supported releases.

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.