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

"Mika Fischer" <mf+ubuntu@zoopnet.de> writes:
> 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.

Are you suggesting that the shell should invoke psql without any idea of
appropriate connection parameters?  This seems utterly foolish.

            regards, tom lane