how to create csv file from postgres python 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