Cheat Sheet logoCheat Sheet Today
psql Cheat Sheet/Export query to CSV

Client-side export of a query result to CSV.

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

Export query to CSV

sql
sql
\copy (SELECT * FROM public.users ORDER BY user_id) TO '/tmp/users.csv' CSV HEADER
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
CSV output
Render result output as CSV.
OpenIn sheetsqlsame section
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
Write query output to file
Send query output to a file until reset.
OpenIn sheetsqlsame section