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 [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
