Thread: non postgres user need to perform COPY

non postgres user need to perform COPY

From
Jaume Teixi
Date:
Hello,

I'm setting up a php interface for a customer massive update of a database
by previously sending a comma separated file trought ftp or a http-file
system.

Now I found that only postgres user is able to perform COPY's.
"
You must have Postgres superuser privilege to do a COPY directly to or
from a file.
Anyone can COPY to stdout or from stdin. Psql's \copy command also works
for anyone.
"

is it right to do it trought postgres user ?
whats the differents between COPY and Psql's \copy as stated above ?


thanks,

teixi from barcelona.