[google-cloud-sql-discuss] cant export from pgadmin to csv on mac (permission denied)

Hello,

Im trying to export table data from PGadmin as follows:

COPY db_name.table_name TO '/tmp/New Folder/first_list_data.sql' DELIMITER ',' CSV HEADER

And I get the error:

ERROR: could not open file "/tmp/New Folder/first_list_data.sql" for writing: Permission denied HINT: COPY TO instructs the PostgreSQL server process to write a file. You may want a client-side facility such as psql's \copy. SQL state: 42501

how can I allow PGadmin to export this file to my mac?

thanks

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/c041229e-f499-4605-a5c3-9364623ed044n%40googlegroups.com.