>The problem isn't permission for copy, it permission to access files. >only the super user can access the file system through pgsql, because of >security concerns. >copy can be run by anybody. copy from/to a FILE can only be done by the >super user. >Have you tried queueing up copy from stdin and a stream of data and \. >in ODBC? I'm pretty sure that'll work, but I've never tried it. I imagine that your solution would work, but the larger issue is that I am sending the SQL from an R program, and not using the psql console. I could launch it the console programmatically and send copy commands to it, but that's just adding more moving parts. Having everyone be a superuser is good enough for now, thanks anyway. -Jim Cser
