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),
I use the SQL statement COPY FROM, which requires me
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 searched our list archives?
http
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,
because
of
security concerns.
copy can be run by anybody
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
. 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
choose an index scan