psql --host=localhost --dbname=db --username=foobar
Never issue a password prompt. If the server requires password authentication and a password is not
available by other means such as a .pgpass file, the connection attempt will fail.
Force psql to prompt for a password before connecting to a database.
So how do I connect without a password prompt?