Thread: 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