psql2csv

Run a query in psql and output the result as CSV.

$ psql2csv dbname “select * from table” > data.csv

$ psql2csv dbname < query.sql > data.csv

$ psql2csv –no-header –delimiter=$’\t’ –encoding=latin1 dbname < SELECT *
> FROM some_table
> WHERE some_condition
> LIMIT 10
> sql