Cheat Sheet logoCheat Sheet Today
psql Cheat Sheet/Set psql variable

Create or update a psql variable.

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

Set psql variable

sql
sql
\set schema_name public
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
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
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