dropdb man page on Scientific

Man page or keyword search:  
man Server   26626 pages
apropos Keyword Search (all sections)
Output format
Scientific logo
[printable version]

DROPDB(1)		PostgreSQL Client Applications		     DROPDB(1)

       dropdb - remove a PostgreSQL database

       dropdb [ option... ]  dbname

       dropdb destroys an existing PostgreSQL database.	 The user who executes
       this command must be a database superuser or the owner of the database.

       dropdb is a wrapper around the SQL command  DROP	 DATABASE  [drop_data‐
       base(7)].   There is no effective difference between dropping databases
       via this utility and via other methods for accessing the server.

       dropdb accepts the following command-line arguments:

       dbname Specifies the name of the database to be removed.


       --echo Echo the commands that dropdb generates and sends to the server.


	      Issues a verification prompt before doing anything destructive.

       dropdb also accepts the following command-line arguments for connection

       -h host

       --host host
	      Specifies	 the  host  name of the machine on which the server is
	      running. If the value begins with a slash, it  is	 used  as  the
	      directory for the Unix domain socket.

       -p port

       --port port
	      Specifies	 the  TCP port or local Unix domain socket file exten‐
	      sion on which the server is listening for connections.

       -U username

       --username username
	      User name to connect as.


	      Never issue a password prompt. If the server  requires  password
	      authentication  and  a  password is not available by other means
	      such as a .pgpass file, the connection attempt will  fail.  This
	      option  can be useful in batch jobs and scripts where no user is
	      present to enter a password.


	      Force dropdb to prompt for a password  before  connecting	 to  a

	      This  option is never essential, since dropdb will automatically
	      prompt for a password if the server demands password authentica‐
	      tion.   However,	dropdb will waste a connection attempt finding
	      out that the server wants a password.  In some cases it is worth
	      typing -W to avoid the extra connection attempt.



       PGUSER Default connection parameters

       This utility, like most other PostgreSQL utilities, also uses the envi‐
       ronment variables supported by libpq (see in the documentation).

       In case of difficulty, see DROP DATABASE [drop_database(7)] and psql(1)
       for discussions of potential problems and error messages.  The database
       server must be running at the targeted host. Also, any default  connec‐
       tion  settings  and  environment	 variables used by the libpq front-end
       library will apply.

       To destroy the database demo on the default database server:

       $ dropdb demo

       To destroy the database demo using the server on host eden, port	 5000,
       with verification and a peek at the underlying command:

       $ dropdb -p 5000 -h eden -i -e demo
       Database "demo" will be permanently deleted.
       Are you sure? (y/n) y
       DROP DATABASE demo;

       createdb(1), DROP DATABASE [drop_database(7)]

Application			  2013-10-08			     DROPDB(1)

List of man pages available for Scientific

Copyright (c) for man pages and the logo by the respective OS vendor.

For those who want to learn more, the polarhome community provides shell access and support.

[legal] [privacy] [GNU] [policy] [cookies] [netiquette] [sponsors] [FAQ]
Polarhome, production since 1999.
Member of Polarhome portal.
Based on Fawad Halim's script.
Vote for polarhome
Free Shell Accounts :: the biggest list on the net