>>> Scott Marlowe <smarlowe@xxxxxxxxxxxxxxxxx> 07/06/06 1:23 PM >>> 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. >p.s., you may be thinking of \copy, which isn't the same as copy from... >just fyi... >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 Sorry, I was just confused over what exactly "stdin" means. I'll go back to the R docs and find out how to stream data. -Jim Cser
