Обсуждение: dropdb cmd line args

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

"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