Use PGPASSFILE

bash

PGPASSFILE=./.pgpass psql -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.

Same sheet · prioritizing Connecting and Session Variables

Interpolate a psql variable in a command.

Open In sheetsqlsame section

Execute a single SQL command from the shell.

Open In sheetbashsame section

Connect with explicit connection flags.

Open In sheetbashsame section

Fail instead of prompting for a password.

Open In sheetbashsame section

Always prompt for the password interactively.

Open In sheetbashsame section

Create or update a psql variable.

Open In sheetsqlsame section