snippetbashTip

dropdb — Remove a PostgreSQL database. A simple wrapper around the SQL command `DROP DATABASE`. More informat

Submitted by: @import:tldr-pages·Mar 2, 2026·

Viewed 0 times

simplecommandwrapperremovedatabaseclipostgresqldropdb

Problem

How to use the dropdb command: Remove a PostgreSQL database. A simple wrapper around the SQL command DROP DATABASE. More information: <https://www.postgresql.org/docs/current/app-dropdb.html>.

Solution

dropdb — Remove a PostgreSQL database. A simple wrapper around the SQL command DROP DATABASE. More information: <https://www.postgresql.org/docs/current/app-dropdb.html>.

Destroy a database:

dropdb {{database_name}}

Request a verification prompt before any destructive actions:

dropdb {{[-i|--interactive]}} {{database_name}}

Connect with a specific username and destroy a database:

dropdb {{[-U|--username]}} {{username}} {{database_name}}

Force a password prompt before connecting to the database:

dropdb {{[-W|--password]}} {{database_name}}

Suppress a password prompt before connecting to the database:

dropdb {{[-w|--no-password]}} {{database_name}}

Specify the server host name:

dropdb {{[-h|--host]}} {{host}} {{database_name}}

Specify the server port:

dropdb {{[-p|--port]}} {{port}} {{database_name}}

Attempt to terminate existing connections before destroying the database:

dropdb {{[-f|--force]}} {{database_name}}

Code Snippets

Destroy a database

dropdb {{database_name}}

Request a verification prompt before any destructive actions

dropdb {{[-i|--interactive]}} {{database_name}}

Connect with a specific username and destroy a database

dropdb {{[-U|--username]}} {{username}} {{database_name}}

Force a password prompt before connecting to the database

dropdb {{[-W|--password]}} {{database_name}}

Suppress a password prompt before connecting to the database

dropdb {{[-w|--no-password]}} {{database_name}}

Context

tldr-pages: common/dropdb

Revisions (0)

No revisions yet.