Fw: problems with copy command
От | Paolo Zampieri |
---|---|
Тема | Fw: problems with copy command |
Дата | |
Msg-id | 015301bfb9ca$bcf26dc0$344714ac@zampieri обсуждение исходный текст |
Ответы |
Re: Fw: problems with copy command
|
Список | pgsql-general |
because apache can only run as nobody, in my case. I thought about it already, I guess the only sulution is stdin. bye Paolo ----- Original Message ----- From: "Frank Bax" <fbax@execulink.com> To: "Paolo Zampieri" <pzampier@it.ip-plus.net> Sent: Tuesday, May 09, 2000 5:16 PM Subject: Re: [GENERAL] problems with copy command > Why not just use a different userid (perhaps the userid you used with psql) > when connecting to the database? > > Frank > > At 04:53 PM 5/09/00 +0200, you wrote: > >hello everybody, > >I tried to copy a file into a table from the postgres terminal, and all > >worked fine. > >But when I tryed the same with the php pg_exec() command the result was: > > > >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? > > > >hope will interest > >bye > > > > > > >
В списке pgsql-general по дате отправления: