Re: [PATCH] COPY vs \copy HINT

Поиск
Список
Период
Сортировка
От Craig Ringer
Тема Re: [PATCH] COPY vs \copy HINT
Дата
Msg-id CAMsr+YE5cBopHZwsQHqrjAWpQp0HzU6b-rxApm3TbcRRpw3yAA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [PATCH] COPY vs \copy HINT  (Christoph Berg <myon@debian.org>)
Ответы Re: [PATCH] COPY vs \copy HINT  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
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.

--
 Craig Ringer                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services
Вложения

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Mark Kirkwood
Дата:
Сообщение: Re: Btree Index on PostgreSQL and Wiredtiger (MongoDB3.2)
Следующее
От: Aleksander Alekseev
Дата:
Сообщение: Re: [Patch] New psql prompt substitution %r (m = master, r = replica)