Fw: problems with copy command
От | Paolo Zampieri |
---|---|
Тема | Fw: problems with copy command |
Дата | |
Msg-id | 016a01bfb9ce$bd20ace0$344714ac@zampieri обсуждение исходный текст |
Список | 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@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 >
В списке pgsql-general по дате отправления: