Re: What's wrong with COPY rights in 7.3.4?

COPY is done with the rights of the server backend, not your client. 
You can also use \copy in psql and that is done in the client.

---------------------------------------------------------------------------

Olivier Hubaut wrote:
> Hi,
> 
> I tried to use the COPY function in v7.3.4 but I have a problem. 
> According to the documentation, anyboy having the good rights on the 
> table he want to copy could do it without any problem.
> 
> When I tried it, I found that using this command is impossible if you 
> aren't an administrator for the instance of PostgreSQL.
> 
> Is it a bug or a *feature*?
> 
> The commands I tried are the followings:
> 
> COPY table FROM '/file.sql';
> 
> and
> 
> COPY table TO '/file.sql';
> 
> Thanks for responding.
> 
> -- 
> Ci-git une signature avortee.
> ** RIP **
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
> 

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073