Cheat Sheet logoCheat Sheet Today
psql Cheat Sheet/CSV output

Render result output as CSV.

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

CSV output

sql
sql
\pset format csv
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
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
Export query to CSV
Client-side export of a query result to CSV.
OpenIn sheetsqlsame section
Write query output to file
Send query output to a file until reset.
OpenIn sheetsqlsame section