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 expected. :] Thanks again. Pedro Doria Meunier GSM: +351961720188 Skype: pdoriam On Tuesday 06 January 2009 06:48:47 pm Scott Marlowe wrote: > On Tue, Jan 6, 2009 at 11:41 AM, Pedro Doria Meunier > > <pdoria@xxxxxxxxxxxxxx> 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 into COPY to a+rw ... > > > > I switched users with su - postgres and connected to the DB with the psql > > command > > > > All I'm getting is a Permission denied upon issuing the COPY command from > > within psql interactive terminal! :O > > What is the exact error you're getting? > > It's better to usually use copy from stdin which has none of these > problems. It's the same syntax tat pg_dump uses when it creates a > backup. > > For example: > > COPY b (a_i, b) FROM stdin; > 1 moreabc > \.
Attachment:
signature.asc
Description: This is a digitally signed message part.
