Скачать или смотреть How to save PostgreSQL psql query output in CSV or TEXT format to a file

http://fosshelp.blogspot.in/2017/03/h...
sql - Save PL/pgSQL output from PostgreSQL to a CSV file
postgresql - psql - save results of command to a file
Save PL/pgSQL output from PostgreSQL to a CSV file
shell - How to export a PostgreSQL query output to a csv file
Saving an output of PostgreSQL query to a text file
PostgreSQL how to redirect output to a file
Simple Export to CSV with Postgres Example
\copy (select * from audityear) TO '/tmp/test1.csv' (format CSV);
\copy (select * from audityear) TO '/tmp/test1.csv' (format CSV, delimiter ',');
\copy (select * from audityear) TO '/tmp/test1.csv' (format CSV, delimiter ',', HEADER);
OR
\copy (select * from audityear) TO '/tmp/test1.csv' (format TEXT);
\copy (select * from audityear) TO '/tmp/test1.csv' (format TEXT, delimiter ',');
OR
\copy (select * from audityear) TO '/tmp/test1.csv' WITH CSV
\copy (select * from audityear) TO '/tmp/test1.csv' WITH CSV HEADER;