psql Cheat Sheet/Force password prompt

Always prompt for the password interactively.

Section: Connecting and Session Variables

Force password prompt

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
Never prompt for password
Fail instead of prompting for a password.
OpenIn sheetbashsame section
Connect with host port user and database
Connect with explicit connection flags.
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