Fw: problems with copy command
in wich sense, I should give a file or a pipe in the copy command, how can I
insert the string of the file, manipulating it by hand and executing an
insert sql?
bye Paolo
----- Original Message -----
From: "Robert B. Easter" <reaster@comptechnews.com>
To: "Paolo Zampieri" <pzampier@it.ip-plus.net>; "Paolo Zampieri"
<pzampier@it.ip-plus.net>; <pgsql-general@postgresql.org>
Sent: Tuesday, May 09, 2000 5:35 PM
Subject: Re: [GENERAL] problems with copy command
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
Show quoted text
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