X-Original-To: pgsql-general@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 5FFA7476022 for ; Sun, 11 May 2003 12:58:53 -0400 (EDT) Received: from varsoon.wireboard.com (www.wireboard.com [216.151.155.101]) by postgresql.org (Postfix) with ESMTP id C79A34758F1 for ; Sun, 11 May 2003 12:58:48 -0400 (EDT) Received: from doug by varsoon.wireboard.com with local (Exim 3.35 #1) id 19Eu9r-0007WV-00; Sun, 11 May 2003 12:58:43 -0400 To: Ron Johnson Cc: pgsql-general@postgresql.org Subject: Re: realtime data inserts References: <6754.1052582402@sss.pgh.pa.us> <1052591490.26574.161.camel@haggis> <10704.1052621185@sss.pgh.pa.us> <1052672090.995.13.camel@haggis> From: Doug McNaught Date: 11 May 2003 12:58:43 -0400 In-Reply-To: Ron Johnson's message of "11 May 2003 11:54:50 -0500" Message-ID: Lines: 18 User-Agent: Gnus/5.0806 (Gnus v5.8.6) Emacs/20.7 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Spam-Status: No, hits=-38.8 required=5.0 tests=BAYES_01,EMAIL_ATTRIBUTION,IN_REP_TO,QUOTED_EMAIL_TEXT, REFERENCES,REPLY_WITH_QUOTES,USER_AGENT_GNUS_UA autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200305/338 X-Sequence-Number: 41993 Ron Johnson writes: > On Sat, 2003-05-10 at 21:46, Tom Lane wrote: > > Ron Johnson writes: > > > On Sat, 2003-05-10 at 11:00, Tom Lane wrote: > > >> Have you thought about using COPY? > > > > > Generate a temporary file, and then system("COPY /tmp/foobar ...") ? > > > > No, copy from stdin. No need for a temp file. > > But wouldn't that only work if the input stream is acceptable to > COPY ? Yes, but you could always pipe it through a script or C program to make it so... -Doug