PostgreSQL Administration Cheat Sheet/Drop database from shell

Drop a database using the `dropdb` utility.

Section: Database Administration Utilities

Drop database from shell

bash
bash
dropdb -h localhost -U postgres appdb
Explanation

See summary for usage details.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Related commands

Same sheet · prioritizing Database Administration Utilities
Create database from shell
Create a database using the `createdb` utility.
OpenIn sheetbashsame section
Create role from shell
Interactively create a new role.
OpenIn sheetbashsame section
Drop role from shell
Remove a role using the command-line utility.
OpenIn sheetbashsame section
Reindex database
Rebuild indexes in a database.
OpenIn sheetbashsame section
Vacuum and analyze
Run vacuum/analyze from the shell.
OpenIn sheetbashsame section
Physically reorder table
Rewrite a table using an index order.
OpenIn sheetsqlsame section