Export table from postgres to local csv - OXPHOS/GeneMiner GitHub Wiki
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;
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;