Editing Delete database


= =[[PostgreSQL]] ==
* <code>DROP DATABASE [IF EXISTS] database_name;</code>
DROP DATABASE


== See also ==
* {{TOC operation databases}}


[[Category:Databases]]
@@ Line 1: / Line 1: @@
-* https://www.postgresql.org/docs/current/sql-dropdatabase.html
-== [[PostgreSQL]] ==
+= =[[PostgreSQL]] ==
- [[DROP DATABASE]] [IF EXISTS] [[my_database_name]][[;]]
+* <code>DROP DATABASE [IF EXISTS] database_name;</code>
-Do not forget the <code>;</code> at the end of the line
+DROP DATABASE
+== See also ==
+* {{TOC operation databases}}
- [[DROP DATABASE]] [IF EXISTS] [[my_database_name]] (FORCE) [[;]]
- Note: FORCE introduced in 2022 ([[PostgreSQL 13]])
- DROP DATABASE database_name;
- Output:
- DROP DATABASE
- DROP DATABASE database_name (FORCE);
- ERROR: database "XXXXX" is being accessed by other users
- DETAIL: There are 4 other sessions using the database
-Related terms:
-* <code>[[sudo -u postgres psql]]</code>
-* <code>[[community.postgresql.postgresql_db_module]]: state: [[absent]]</code>
-== Related ==
-* <code>[[DELETE]]</code>
-* <code>[[DROP TABLE]]</code>
-* <code>[[CREATE DATABASE]]</code>
-* <code>[[\list]]</code>
-* [[PostgreSQL superuser]]
-* <code> [[ALTER DATABASE]]</code>
-* <code> [[ERROR: must be owner of database]]</code>
-* <code> [[GRANT "your-defined role" TO "your username";]]</code
->
-== See also ==
-* {{DROP}}
-* {{Database ops}}
-* {{Role}}
 [[Category:Databases]]