BUG #4040: psql should provide option to not prompt for password

The following bug has been logged online:

Bug reference:      4040
Logged by:          Mika Fischer
Email address:      mf+ubuntu@zoopnet.de
PostgreSQL version: 8.3.0
Operating system:   Ubuntu Linux 8.4 beta
Description:        psql should provide option to not prompt for password
Details:

Hi,

I'm currently working on the bash-completion package. The problem with
postgresql is that psql cannot safely be called because there is no way to
know whether it will prompt for a password and there is also no way to avoid
the prompt.

Needless to say a password prompt is very bad in the context of
tab-completion.

Ideally, psql should provide an option --no-password which would cause it to
never promt for a password, and in case one is needed, fail as if a wrong
one was given.

However if you can think of an easier way to accomplish this, I'd be
grateful for pointers.

Thanks for considering,
 Mika