how to export data to excel from postgres line command code example
Example: run postgresql dump to csv
\copy (SELECT * FROM persons) to 'C:\tmp\persons_client.csv' with csv
\copy (SELECT * FROM persons) to 'C:\tmp\persons_client.csv' with csv