Saturday, 18 May 2019

Postgres: Drop database


Using ‘DROP DATABASE’ command, you can drop a database. Login to any database apart from the one that you want to delete and execute 'DROP DATABASE {database_name}' command.

$psql -U postgres -h localhost --dbname=postgres
Password for user postgres: 
psql (14.4)
Type "help" for help.

postgres=# 
postgres=# \l
                             List of databases
   Name    |  Owner   | Encoding | Collate | Ctype |   Access privileges   
-----------+----------+----------+---------+-------+-----------------------
 myOrg     | postgres | UTF8     | C       | C     | 
 postgres  | postgres | UTF8     | C       | C     | 
 template0 | postgres | UTF8     | C       | C     | =c/postgres          +
           |          |          |         |       | postgres=CTc/postgres
 template1 | postgres | UTF8     | C       | C     | =c/postgres          +
           |          |          |         |       | postgres=CTc/postgres
(4 rows)

postgres=# 
postgres=# DROP DATABASE "myOrg";
DROP DATABASE
postgres=# 
postgres=# \l
                             List of databases
   Name    |  Owner   | Encoding | Collate | Ctype |   Access privileges   
-----------+----------+----------+---------+-------+-----------------------
 postgres  | postgres | UTF8     | C       | C     | 
 template0 | postgres | UTF8     | C       | C     | =c/postgres          +
           |          |          |         |       | postgres=CTc/postgres
 template1 | postgres | UTF8     | C       | C     | =c/postgres          +
           |          |          |         |       | postgres=CTc/postgres
(3 rows)
 
Previous                                                 Next                                                 Home

No comments:

Post a Comment