Douglas McNaught <doug@xxxxxxxxxxxx> writes: > You can use \copy in 'psql' on the client side, but you have to be a > superuser to do COPY on the server side, for security reasons. I wonder if there's any way to relax this constraint. If you're connected via a unix domain socket we can know the UID of the client end. I don't see reproducing the entire unix semantics but if file is owned by the same uid as the user connecting it seems like it ought to be safe. -- greg ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
