Store result of a PostgreSQL query as a CSV file

Executes a query against a Postgres database and writes the output to a new file

Brought to you by Warp, a free terminal reimagined to work like a modern app.

query

file_name

Command

psql -d dbname -t -A -F"," -c "query" > file_name