psql Cheat Sheet/Reset output target

Return output to stdout.

Section: Formatting and Output Control

Reset output target

sql
sql
\o
Explanation

See summary for usage details.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Related commands

Same sheet · prioritizing Formatting and Output Control
Write query output to file
Send query output to a file until reset.
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