psql Cheat Sheet/Never prompt for password

Fail instead of prompting for a password.

Section: Connecting and Session Variables

Never prompt for password

bash
bash
psql -w -h localhost -U appuser -d appdb
Explanation

See summary for usage details.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Related commands

Same sheet · prioritizing Connecting and Session Variables
Connect with host port user and database
Connect with explicit connection flags.
OpenIn sheetbashsame section
Force password prompt
Always prompt for the password interactively.
OpenIn sheetbashsame section
Set psql variable
Create or update a psql variable.
OpenIn sheetsqlsame section
Use psql variable in SQL
Interpolate a psql variable in a command.
OpenIn sheetsqlsame section
Show current connection
Display current host, port, user, and database connection info.
OpenIn sheetsqlsame section
Use PGPASSFILE
Use a password file for noninteractive authentication.
OpenIn sheetbashsame section