Re: REPEATED INSERT INTO ... 2nd thread - Mailing list pgsql-hackers

From Neil Conway
Subject Re: REPEATED INSERT INTO ... 2nd thread
Date
Msg-id 1046192387.427.13.camel@tokyo
Whole thread Raw
In response to Re: REPEATED INSERT INTO ... 2nd thread  (Christoph Haller <ch@rodos.fzk.de>)
List 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 by date:

Previous
From: Darko Prenosil
Date:
Subject: Re: I cant find it or I'm just lazy ?
Next
From: "Jeroen T. Vermeulen"
Date:
Subject: Re: I cant find it or I'm just lazy ?