PostgreSQL - CLI.md

SELECT TO CSV

\copy (SELECT * FROM table) To '/tmp/psql-output.csv' With CSV

or https://www.postgresql.org/docs/current/static/sql-copy.html

set pager to always

\pset pager always