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