Cheat Sheet logoCheat Sheet Today
psql Cheat Sheet/Connect with host port user and database

Connect with explicit connection flags.

Back to sheetBrowse commands
Sign in to save
Section: Connecting and Session Variables

Connect with host port user and database

bash
bash
psql -h localhost -p 5432 -U appuser -d appdb
Explanation

See summary for usage details.

View in sheet →

Learn the surrounding workflow

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

Compare commandsView fixes

Related commands

Same sheet · prioritizing Connecting and Session Variables
Never prompt for password
Fail instead of prompting for a password.
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