>>> 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
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
>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
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
>>> 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 requir
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
[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, so I would like to
