postgres produce a csv file from a query code example

Example: run postgresql dump to csv

\copy (SELECT * FROM persons) to 'C:\tmp\persons_client.csv' with csv