[GENERAL] Granting COPY FROM access

2006-07-06 Thread Jim Cser
>>> Scott Marlowe <[EMAIL PROTECTED]> 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, becau

[GENERAL] Granting COPY FROM access

2006-07-06 Thread Jim Cser
he 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 ---(end of broadcast)--- TIP 4: Have you se

[GENERAL] Granting COPY FROM access

2006-07-06 Thread Jim Cser
>>> Chris <[EMAIL PROTECTED]> 07/05/06 7:49 PM >>> > 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), >

[GENERAL] Granting COPY FROM access

2006-07-05 Thread Jim Cser
sion to do COPY FROM. So, my question is: can COPY FROM permission be granted to a non-superuser, or is there something else that I missed? -Jim Cser ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to

[GENERAL] Granting COPY TO access

2006-07-05 Thread Jim Cser
estion is: can COPY FROM permission be granted to a non-superuser, or is there something else that I missed? -Jim Cser ---(end of broadcast)--- TIP 6: explain analyze is your friend