Cheat Sheet logoCheat Sheet Today
psql Cheat Sheet/Conditional blocks in psql

Use psql conditionals in interactive or scripted sessions.

Back to sheetBrowse commands
Sign in to save
Section: Scripting and Automation

Conditional blocks in psql

sql
sql
\if :{?target_schema}
  \echo 'target schema set'
\else
  \echo 'target schema missing'
\endif
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 Scripting and Automation
Stop on first error
Exit immediately when a script encounters an error.
OpenIn sheetbashsame section
Pass variable on command line
Inject psql variables from the shell.
OpenIn sheetbashsame section
Echo all commands
Print input lines as they are executed.
OpenIn sheetbashsame section
Echo hidden commands
Show underlying SQL generated by backslash commands.
OpenIn sheetbashsame section
Execute script in one transaction
Wrap the script in a single transaction.
OpenIn sheetbashsame section
Include another script
Read and execute another SQL file.
OpenIn sheetsqlsame section