Cheat Sheet logoCheat Sheet Today
psql Cheat Sheet/Write query output to file

Send query output to a file until reset.

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

Write query output to file

sql
sql
\o /tmp/query-output.txt
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
Reset output target
Return output to stdout.
OpenIn sheetsqlsame section
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
Set NULL display
Customize how null values are shown.
OpenIn sheetsqlsame section