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

Hello,

This is a discussion group for the Cloud SQL product, which is not affiliated to pgAdmin. For that reason, the support you would get for permission issue your are facing with pgAdmin would be limited here.

Nevertheless, I have found a Stack post for the same error message when attempting to import a file on Windows 7. That error is likely caused by the user not having read permission to that file, and needs to be added.

Since that way to modify permissions is for Windows, you would need to do so using Mac's Terminal.

Alternatively, I believe that this article might interest you, as it mentions the use of psql's \copy, just like the error message, and the pgAdmin GUI. For psql, the command would be `$ \copy table_name to 'filename.csv' csv header` as per this link.

--
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/8f50df65-ef01-460d-9bbd-2d6227e15baao%40googlegroups.com.