Thread: Fw: problems with copy command

Fw: problems with copy command

From
"Paolo Zampieri"
Date:
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
> > 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
>