From 293913568e6a7a86fd1479e1cff8e2ecb58d6568 Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sat, 13 Apr 2024 15:44:03 +0200 Subject: Adding upstream version 16.2. Signed-off-by: Daniel Baumann --- doc/src/sgml/ref/drop_database.sgml | 126 ++++++++++++++++++++++++++++++++++++ 1 file changed, 126 insertions(+) create mode 100644 doc/src/sgml/ref/drop_database.sgml (limited to 'doc/src/sgml/ref/drop_database.sgml') diff --git a/doc/src/sgml/ref/drop_database.sgml b/doc/src/sgml/ref/drop_database.sgml new file mode 100644 index 0000000..ff01450 --- /dev/null +++ b/doc/src/sgml/ref/drop_database.sgml @@ -0,0 +1,126 @@ + + + + + DROP DATABASE + + + + DROP DATABASE + 7 + SQL - Language Statements + + + + DROP DATABASE + remove a database + + + + +DROP DATABASE [ IF EXISTS ] name [ [ WITH ] ( option [, ...] ) ] + +where option can be: + + FORCE + + + + + Description + + + DROP DATABASE drops a database. It removes the + catalog entries for the database and deletes the directory + containing the data. It can only be executed by the database owner. + It cannot be executed while you are connected to the target database. + (Connect to postgres or any other database to issue this + command.) + Also, if anyone else is connected to the target database, this command will + fail unless you use the FORCE option described below. + + + + DROP DATABASE cannot be undone. Use it with care! + + + + + Parameters + + + + IF EXISTS + + + Do not throw an error if the database does not exist. A notice is issued + in this case. + + + + + + name + + + The name of the database to remove. + + + + + + FORCE + + + Attempt to terminate all existing connections to the target database. + It doesn't terminate if prepared transactions, active logical replication + slots or subscriptions are present in the target database. + + + This will fail if the current user has no permissions to terminate other + connections. Required permissions are the same as with + pg_terminate_backend, described in + . This will also fail if we + are not able to terminate connections. + + + + + + + + + Notes + + + DROP DATABASE cannot be executed inside a transaction + block. + + + + This command cannot be executed while connected to the target + database. Thus, it might be more convenient to use the program + instead, + which is a wrapper around this command. + + + + + Compatibility + + + There is no DROP DATABASE statement in the SQL standard. + + + + + See Also + + + + + + -- cgit v1.2.3