Re: REPEATED INSERT INTO ... 2nd thread
От | Neil Conway |
---|---|
Тема | Re: REPEATED INSERT INTO ... 2nd thread |
Дата | |
Msg-id | 1046192387.427.13.camel@tokyo обсуждение исходный текст |
Ответ на | Re: REPEATED INSERT INTO ... 2nd thread (Christoph Haller <ch@rodos.fzk.de>) |
Список | pgsql-hackers |
On Tue, 2003-02-25 at 03:59, Christoph Haller wrote: > for (CmdIndex = start_index; CmdIndex < nRows; CmdIndex++) > { > sprintf(CmdLine, > "INSERT INTO AArray_Values ( Primary_Key, List_Pointer,\ > Parameter_Name, Parameter_Code,\ > Dim_Pointer, File_Pointer, Source_Type )\ > VALUES ( %d,%d,'%s',%d,%d,%d,'%s' );", > AArray_Values[CmdIndex].primary_key, > AArray_Values[CmdIndex].value_list_ptr, > AArray_Values[CmdIndex].parameter_name, > AArray_Values[CmdIndex].parameter_code, > AArray_Values[CmdIndex].dim_pointer, > AArray_Values[CmdIndex].file_pointer, > AArray_Values[CmdIndex].source_type); > /* > call PQexec() to process > */ > } > How would you replace this by COPY? something like ... PQexec("COPY xxx FROM stdin"); for (...) { sprintf(buf, "%d\t%d\t...\n", values[0], values[1], ... values[n]); PQputline(conn, buf); } PQputline(conn, "\\.\n"); PQendcopy(conn); Cheers, Neil -- Neil Conway <neilc@samurai.com> || PGP Key ID: DB3C29FC
В списке pgsql-hackers по дате отправления: