On 12 August 2016 at 16:34, Christoph Berg <myon@debian.org> wrote:
> postgres=# COPY x TO '/root/nopermissions'; > ERROR: could not open file "/root/nopermissions" for writing: Permission > denied > HINT: Paths for COPY are on the PostgreSQL server, not the client. You may > want psql's \copy or a driver COPY ... FROM STDIN wrapper
TO STDOUT.
Ahem, whoops. It's the simple things sometimes...
Attached amended.
Also, I vaguely get what you wanted to say with "a driver ... wrapper", but it's pretty nonsensical if one doesn't know about the protocol details. I don't have a better suggestion now, but I think it needs rephrasing.
I don't like it either, but didn't come up with anything better. The problem is that every driver calls it something different.
