How can I store the result of a SQL query in a CSV file using Squirrel?

user_278998 0
Viewed 50137

Version 3.0.3. It's a fairly large result-set, around 3 million rows.

squirrel-sql csv postgresql sql
5 Answers

Run from your GUI:

COPY (SELECT * FROM some_table) TO '/some/path/some_table.csv' WITH CSV HEADER

user_2346950
Related