Alvaro Herrera <[EMAIL PROTECTED]> writes: > I have never understood what's the point of having an option to force a > password prompt. I wonder why don't we deprecate -W?
It's not *completely* useless, because you only need one connection attempt not two --- normally, psql gets rejected once before figuring out that it must ask for a password. You can imagine scenarios with slow internet connections, or a badly overloaded database, where it might be worth the keystrokes to type -W. OTOH, you can also avoid the two-attempts syndrome with a ~/.pgpass file. On balance I'm not for deprecating it, but pointing out that it's normally useless doesn't seem out of line... regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate