Cheat Sheet logoCheat Sheet Today
psql Cheat Sheet/Set NULL display

Customize how null values are shown.

Back to sheetBrowse commands
Sign in to save
Section: Formatting and Output Control

Set NULL display

sql
sql
\pset null '[NULL]'
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 Formatting and Output Control
Unaligned output
Print output without table borders for scripting.
OpenIn sheetsqlsame section
CSV output
Render result output as CSV.
OpenIn sheetsqlsame section
Tuples only
Suppress headers and footers.
OpenIn sheetsqlsame section
Set border style
Adjust table border rendering.
OpenIn sheetsqlsame section
Write query output to file
Send query output to a file until reset.
OpenIn sheetsqlsame section
Reset output target
Return output to stdout.
OpenIn sheetsqlsame section