dropdb

Name

dropdb -- PostgreSQLµ¥ÀÌÅͺ£À̽º¸¦ »èÁ¦ÇÑ´Ù.

Synopsis

dropdb [ option ...] dbname

¼³¸í

dropdb´Â ±âÁ¸¿¡ Á¸ÀçÇÏ´Â PostgreSQLÀÇ µ¥ÀÌÅͺ£À̽º¸¦ »èÁ¦ÇÕ´Ï´Ù. ÀÌ ¸í·ÉÀº µ¥ÀÌÅͺ£À̽ºÀÇ ½´ÆÛÀ¯Àú ¶Ç´Â µ¥ÀÌÅͺ£À̽ºÀÇ ¼ÒÀ¯ÀÚ¸¸ ½ÇÇàÇÒ ¼ö ÀÖ½À´Ï´Ù.

dropdb´Â DROP DATABASE SQL¸í·ÉÀÇ ÁÖÀ§¸¦ µÑ·¯½Î°í ÀÖ½À´Ï´Ù. À¯Æ¿¸®Æ¼¸¦ ÅëÇØ µ¥ÀÌÅͺ£À̽º¸¦ »èÁ¦ÇÏ´Â °Í°ú ¼­¹öÀÇ Á¢±Ù¼ºÀ» À§ÇØ ÀÌ¿ÜÀÇ ¹æ¹ýÀ¸·Î µ¥ÀÌÅͺ£À̽º¸¦ »èÁ¦ÇÏ´Â °ÍÀÇ ´«¿¡ ¶ç´Â Â÷À̰¡ ¾ø½À´Ï´Ù.

¿É¼Ç

dropdb´Â ¾Æ·¡¿Í °°Àº ¸í·É-¶óÀÎ Àμö¸¦ ¹Þ¾ÆµéÀÔ´Ï´Ù.

dbname

»èÁ¦ÇÏ´Â µ¥ÀÌÅͺ£À̽º¸íÀ» ÁöÁ¤ÇÕ´Ï´Ù.

-e
--echo

dropdb°¡ »ý¼ºµÇ°í ¼­¹ö·Î º¸³»´Â ±× ¸í·ÉÀ» ¹Ý¿µÇÕ´Ï´Ù.

-i
--interactive

»èÁ¦¸¦ ½ÇÇàÇϱâ Àü¿¡ È®ÀÎ prompt¸¦ Ç¥½ÃÇÕ´Ï´Ù.

-q
--quiet

ÀÀ´äÀ» Ç¥½ÃÇÏÁö ¸¶½Ê½Ã¿À.

¶ÇÇÑ, dropdb´Â ¾Æ·¡¿Í °°ÀÌ ¸í·É ¶óÀÎ Àμö¸¦ Á¢¼Ó ÆÄ¶ó¹ÌÅͷμ­ ¹Þ¾ÆµéÀÔ´Ï´Ù.

-h host
--host host

-p port
--port port

-U username
--username username

-W
--password

ȯ°æ

PGHOST
PGPORT
PGUSER

±âº» ¿¬°á ¸Å°³º¯¼öÀÔ´Ï´Ù.

Áø´Ü

¿¹Á¦

$ 
dropdb demo
DROP DATABASE

$ 
dropdb -p 5000 -h eden -i -e demo
Database "demo" will be permanently deleted.
Are you sure? (y/n) 
y
DROP DATABASE "demo"
DROP DATABASE

°ü·Ã Ç׸ñ

createdb , DROP DATABASE