.\\" auto-generated by docbook2man-spec $Revision: 1.1.1.1 $.TH "DROPDB" "1" "2008-01-03" "Application" "PostgreSQL Client Applications".SH NAMEdropdb \- remove a PostgreSQL database.SH SYNOPSIS.sp\fBdropdb\fR [ \fB\fIoption\fB\fR\fI...\fR ]  \fB\fIdbname\fB\fR.SH "DESCRIPTION".PP\fBdropdb\fR destroys an existingPostgreSQL database.The user who executes this command must be a databasesuperuser or the owner of the database..PP\fBdropdb\fR is a wrapper around theSQL command DROP DATABASE [\fBdrop_database\fR(7)].There is no effective difference between dropping databases viathis utility and via other methods for accessing the server..SH "OPTIONS".PP\fBdropdb\fR accepts the following command-line arguments:.TP\fB\fIdbname\fB\fRSpecifies the name of the database to be removed..TP\fB-e\fR.TP\fB--echo\fREcho the commands that \fBdropdb\fR generatesand sends to the server..TP\fB-i\fR.TP\fB--interactive\fRIssues a verification prompt before doing anything destructive..TP\fB-q\fR.TP\fB--quiet\fRDo not display a response..PP.PP\fBdropdb\fR also accepts the followingcommand-line arguments for connection parameters:.TP\fB-h \fIhost\fB\fR.TP\fB--host \fIhost\fB\fRSpecifies the host name of the machine on which the serveris running. If the value begins with a slash, it is used as the directory for the Unix domain socket..TP\fB-p \fIport\fB\fR.TP\fB--port \fIport\fB\fRSpecifies the TCP port or local Unix domain socket file extension on which the serveris listening for connections..TP\fB-U \fIusername\fB\fR.TP\fB--username \fIusername\fB\fRUser name to connect as.TP\fB-W\fR.TP\fB--password\fRForce password prompt..PP.SH "ENVIRONMENT".TP\fBPGHOST\fR.TP\fBPGPORT\fR.TP\fBPGUSER\fRDefault connection parameters.PPThis utility, like most other PostgreSQL utilities,also uses the environment variables supported by \fBlibpq\fR(see in the documentation)..PP.SH "DIAGNOSTICS".PPIn case of difficulty, see DROP DATABASE [\fBdrop_database\fR(7)] and \fBpsql\fR(1) fordiscussions of potential problems and error messages.The database server must be running at thetargeted host. Also, any default connection settings and environmentvariables used by the \fBlibpq\fR front-endlibrary will apply..SH "EXAMPLES".PPTo destroy the database demo on the defaultdatabase server:.sp.nf$ \fBdropdb demo\fRDROP DATABASE.sp.fi.PPTo destroy the database demo using theserver on host eden, port 5000, with verification and a peekat the underlying command:.sp.nf$ \fBdropdb -p 5000 -h eden -i -e demo\fRDatabase "demo" will be permanently deleted.Are you sure? (y/n) \fBy\fRDROP DATABASE "demo"DROP DATABASE.sp.fi.SH "SEE ALSO"\fBcreatedb\fR(1), DROP DATABASE [\fBdrop_database\fR(7)]