Export table from postgres to local csv

The problems with the regular method: permission deny.

Solution:

sudo chmod 777 target/dir/

Then in psql:

\copy table TO '/target/dir/table.csv' DELIMITER ',' CSV HEADER;