Cheat Sheet logoCheat Sheet Today
psql Cheat Sheet/Run one command and exit

Execute a single SQL command from the shell.

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

Run one command and exit

bash
bash
psql -d appdb -c "SELECT now();"
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
Use psql variable in SQL
Interpolate a psql variable in a command.
OpenIn sheetsqlsame section
Use PGPASSFILE
Use a password file for noninteractive authentication.
OpenIn sheetbashsame section
Connect with host port user and database
Connect with explicit connection flags.
OpenIn sheetbashsame section
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