dropdb cmd line args

Started by samıover 19 years ago2 messagesgeneral
Jump to latest
#1samı
sami.jan@gmail.com

Hi

I am new to Postgres. I am using PostgreSQL 8.1.4 on WinXP.

I tried using dropdb.exe to drop a database I created using pgAdminIII.

It seems to me that dropdb.exe expects arguments in an apparently weird
kind of way.

When I give the program the following arguments, it throws up an error:

dropdb -i -h localhost -p 5432 -U postgres - W password dataBaseToDrop

Error: "dropdb: too many command-line arguments (first is "test1")
Try "dropdb --help" for more information."

However, the following just gives a message I do not expect:

dropdb -i -h localhost -p 5432 -U postgres - W password

Database "password" will be permanently removed.
Are you sure? (y/n) n

Is this acceptable/normail behavior?

Thanks

Sami

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: samı (#1)
Re: dropdb cmd line args

"sami" <sami.jan@gmail.com> writes:

When I give the program the following arguments, it throws up an error:

dropdb -i -h localhost -p 5432 -U postgres - W password dataBaseToDrop

-W does not take the password as an argument on the command line, it
just forces a prompt for the password. (Which will happen anyway if
needed, so really -W is a waste of typing.)

Also, I hope you weren't really spelling it with a space between the
dash and the W...

regards, tom lane