because apache can only run as nobody, in my case.
I thought about it already, I guess the only sulution is stdin.
bye
Paolo
----- Original Message -----
From: "Frank Bax" <fbax@execulink.com>
To: "Paolo Zampieri" <pzampier@it.ip-plus.net>
Sent: Tuesday, May 09, 2000 5:16 PM
Subject: Re: [GENERAL] problems with copy command
> Why not just use a different userid (perhaps the userid you used with
psql)
> when connecting to the database?
>
> Frank
>
> At 04:53 PM 5/09/00 +0200, you wrote:
> >hello everybody,
> >I tried to copy a file into a table from the postgres terminal, and all
> >worked fine.
> >But when I tryed the same with the php pg_exec() command the result was:
> >
> >PostgresSQL query failed: ERROR: You must have Postgres superuser
privilege
> >to do a COPY directly to or from a file. Anyone can COPY to stdout or
from
> >stdin. Psql's \copy command also works for anyone.
> >
> >I can't use \copy from php because there is no \copy interface in php,
only
> >pg_exec(sql command), so the only way is to use stdin!
> >Someone has ideas about how to pipe the file and than read the pipe from
the
> >copy sql command?
> >
> >hope will interest
> >bye
> >
> >
> >
>