non postgres user need to perform COPY - Mailing list pgsql-admin

From Jaume Teixi
Subject non postgres user need to perform COPY
Date
Msg-id 20010327183519.43caf9dc.teixi@6tems.com
Whole thread Raw
List pgsql-admin
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.

pgsql-admin by date:

Previous
From: Jaume Teixi
Date:
Subject: search on accents over all possible matches
Next
From: David Lizano
Date:
Subject: Re: search on accents over all possible matches