On Thu, 2006-07-06 at 15:03, Jim Cser wrote: > >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. You don't need the psql console, that's what I've been trying to say. I do this stuff routinely in php and other languages. Note that if R is generating this data from postgresql to begin with, you might be better off with pl/R
