Re: [PATCH] COPY vs \copy HINT

On 12 August 2016 at 16:34, Christoph Berg <myon(at)debian(dot)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.

--
Craig Ringer http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services