Movatterモバイル変換


[0]ホーム

URL:



Facebook
Postgres Pro
Facebook
Downloads
21.5. Destroying a Database
Prev UpChapter 21. Managing DatabasesHome Next

21.5. Destroying a Database#

Databases are destroyed with the commandDROP DATABASE:

DROP DATABASEname;

Only the owner of the database, or a superuser, can drop a database. Dropping a database removes all objects that were contained within the database. The destruction of a database cannot be undone.

You cannot execute theDROP DATABASE command while connected to the victim database. You can, however, be connected to any other database, including thetemplate1 database.template1 would be the only option for dropping the last user database of a given cluster.

For convenience, there is also a shell program to drop databases,dropdb:

dropdbdbname

(Unlikecreatedb, it is not the default action to drop the database with the current user name.)


Prev Up Next
21.4. Database Configuration Home 21.6. Tablespaces
pdfepub
Go to Postgres Pro Standard 17
By continuing to browse this website, you agree to the use of cookies. Go toPrivacy Policy.

[8]ページ先頭

©2009-2025 Movatter.jp