Granting COPY FROM access

Scott Marlowe <smarlowe@g2switchworks.com> 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