mcrumiller commented on issue #538: URL: https://github.com/apache/arrow-adbc/issues/538#issuecomment-1609972080
Ahh, that's the issue. postgres `COPY` function is only allowed from the backend: https://www.postgresql.org/docs/current/sql-copy.html. See here: > Files named in a COPY command are read or written directly by the server, not by the client application. Therefore, they must reside on or be accessible to the database server machine, not the client. I've run into the past. Further on the page is the following: > Do not confuse `COPY` with the psql instruction [`\copy`](https://www.postgresql.org/docs/current/app-psql.html#APP-PSQL-META-COMMANDS-COPY). `\copy` invokes `COPY FROM STDIN` or `COPY TO STDOUT`, and then fetches/stores the data in a file accessible to the psql client. Thus, file accessibility and access rights depend on the client rather than the server when `\copy` is used. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
