Export CSV of query without COPY
Clients task me to export data to a CSV from time to time. My favorite workflow for authoring queries is a split tmux session, vim (with the excellent coc-sql) on one side, and a
psql session on the other. I modify my query and then re-execute via
This is great, until I'm ready to export the CSV. historically I've edited the query, cumbersomely breaking my REPL flow by turning it into a
COPY command. Now I do this:
\pset format csv \o output-file.csv \i my-query.sql
To reset my
psql session output...
\pset format aligned \o
my-query.sql remains a working query.