From PSQL console $ psql <postgres connection string> => \o result-filename.txt => SELECT * from the table Another variant (CSV export) COPY (SELECT foo, bar FROM baz) TO '/tmp/query.csv' (format csv, delimiter ';')