Pedro Doria Meunier wrote:
> I have created a public folder for the effect and chown'ed both the folder
> and
> the file to be fed into COPY to a+rw ...
The server user (usually via the "group" or "other" permissions blocks)
must also have at least execute ('x') permissions on every directory
b
Hi Scott
Txs for replying.
Anyway I've found the problem (silly me... (blush) )
It had to do (of course) with the "forest" perms in the folder tree ...
As soon as I moved the file into the data/ folder and executed the COPY ...
FROM feeding it the file from that location everything worked as exp
Pedro Doria Meunier writes:
> All I'm getting is a Permission denied upon issuing the COPY command from
> within psql interactive terminal!
Since you didn't show what you did or what the error was, we're just
guessing ... but I'm going to guess that you should use \copy not COPY.
The server norm
On Tue, Jan 6, 2009 at 11:41 AM, Pedro Doria Meunier
wrote:
> Hi All,
>
> This is a bit embarassing ... but ...
>
> I have a partial set of data that I want to restore via COPY ... FROM command
>
> I have created a public folder for the effect and chown'ed both the folder and
> the file to be fed
Hi All,
This is a bit embarassing ... but ...
I have a partial set of data that I want to restore via COPY ... FROM command
I have created a public folder for the effect and chown'ed both the folder and
the file to be fed into COPY to a+rw ...
I switched users with su - postgres and connected
