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
On Tue, Jan 6, 2009 at 11:41 AM, Pedro Doria Meunier
pdo...@netmadeira.com 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
Pedro Doria Meunier pdo...@netmadeira.com 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
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
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
between