Cheat Sheet logoCheat Sheet Today
psql Cheat Sheet/Use psql variable in SQL

Interpolate a psql variable in a command.

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

Use psql variable in SQL

sql
sql
SELECT * FROM :schema_name.users LIMIT 5;
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
Set psql variable
Create or update a psql variable.
OpenIn sheetsqlsame section
Use PGPASSFILE
Use a password file for noninteractive authentication.
OpenIn sheetbashsame section
Run one command and exit
Execute a single SQL command from the shell.
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