From: | "Paolo Zampieri" <pzampier(at)it(dot)ip-plus(dot)net> |
---|---|
To: | "postgres" <pgsql-general(at)postgresql(dot)org> |
Subject: | Fw: problems with copy command |
Date: | 2000-05-09 15:53:37 |
Message-ID: | 016a01bfb9ce$bd20ace0$344714ac@zampieri |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)comptechnews(dot)com>
To: "Paolo Zampieri" <pzampier(at)it(dot)ip-plus(dot)net>; "Paolo Zampieri"
<pzampier(at)it(dot)ip-plus(dot)net>; <pgsql-general(at)postgresql(dot)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(at)comptechnews(dot)com
>
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2000-05-09 16:00:32 | Re: Re: [ANNOUNCE] Steering committee responce to Great Bridge LLC |
Previous Message | Robert B. Easter | 2000-05-09 15:35:18 | Re: problems with copy command |