Re: [GENERAL] Granting COPY FROM access

2006-07-06 Thread Scott Marlowe
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 > t

Re: [GENERAL] Granting COPY FROM access

2006-07-06 Thread Scott Marlowe
On Thu, 2006-07-06 at 13:28, Jim Cser wrote: > >>> Chris <[EMAIL PROTECTED]> 07/05/06 7:49 PM >>> > > >Are you trying from a file or stdin? What error message do you get > when > >you try? > As I mentioned above, I am loading CSV files, and yes, I do read > documentation. It all works just fine

Re: [GENERAL] Granting COPY FROM access

2006-07-05 Thread Chris
Jim Cser wrote: [post header corrected, sorry] I have an application that uses ODBC to access a PostGreSQL 8.0.3 database. To load in text files (comma separated, with column headers), I use the SQL statement COPY FROM, which requires me to be a superuser. I don't need full superuser access, s