| From: | "Robert B(dot) 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> |
| Subject: | Re: problems with copy command |
| Date: | 2000-05-09 15:35:18 |
| Message-ID: | 00050911395203.20915@comptechnews |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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 | Paolo Zampieri | 2000-05-09 15:53:37 | Fw: problems with copy command |
| Previous Message | Ross J. Reedstrom | 2000-05-09 15:31:28 | Re: USMARC and postgresql? |