Must be superuser to COPY from a file? - 08-17-2005 , 03:30 AM
On the attempt to bulk load a table from a file that is owned by the
non-superuser current database user, the following error message is
"must be superuser to COPY to or from a file"
What is the reason for this limitation?
It can't justifiably be for security reasons because if a web
application such as tomcat requires to bulk load tables automatically
on a regular basis then one would be forced to let the web application
connect as superuser, which is very bad for security.
In MySQL bulk loading works for all users.
We need a Postgresql solution.
We have a web application where both MySQL and Postresql are
supported. With Postgresql, the application would have to connect as
user postgres. We have to explain this security risk to our clients
Many thanks for your help