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 <[EMAIL PROTECTED]> || PGP Key ID: DB3C29FC ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster