Difference between revisions of "Drop PostgreSQL Database"

From Gejoreuy
Jump to navigation Jump to search
 
(One intermediate revision by the same user not shown)
Line 5: Line 5:
 
== Drop Database ==
 
== Drop Database ==
  
Just run below command and change it with the database value. '''WARNING : THIS COMMAND WILL DELETE DATABASE!'''
+
Just run below command and change it with the database value.  
 +
<br>'''WARNING : THIS COMMAND WILL DELETE DATABASE!'''
  
 
<pre>
 
<pre>
dropdb -U username -h hostname -p port -i -e databasename
+
[root@gejoreuy ~]# dropdb -U username -h hostname -p port -i -e databasename
 
</pre>
 
</pre>
  

Latest revision as of 10:41, 20 June 2020

Purpose

This topic describes how to use the psql command to removes all the catalog entries and data directory permanently from the PostgreSQL environment.

Drop Database

Just run below command and change it with the database value.
WARNING : THIS COMMAND WILL DELETE DATABASE!

[root@gejoreuy ~]# dropdb -U username -h hostname -p port -i -e databasename

Note :

  • username: The username that to be used to delete PostgreSQL database.
  • hostname: The hostname of the PostgreSQL database.
  • port: The port number of the PostgreSQL database.
  • databasename: The PostgreSQL database name.