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.