On Tue, 09 May 2000, Paolo Zampieri wrote:
> 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?
Just read the file in row at a time and insert them in a loop?
The opposite to copy it out. I think you'll have to do it this way.
--
Robert B. Easter
reaster@comptechnews.com