X-Original-To: pgsql-general@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id CA6DD476302 for ; Sun, 11 May 2003 12:54:45 -0400 (EDT) Received: from lakemtao01.cox.net (lakemtao01.cox.net [68.1.17.244]) by postgresql.org (Postfix) with ESMTP id E6AE1476022 for ; Sun, 11 May 2003 12:54:44 -0400 (EDT) Received: from [192.168.1.1] ([68.11.66.83]) by lakemtao01.cox.net (InterMail vM.5.01.04.05 201-253-122-122-105-20011231) with ESMTP id <20030511165451.RXJG8337.lakemtao01.cox.net@[192.168.1.1]> for ; Sun, 11 May 2003 12:54:51 -0400 Subject: Re: realtime data inserts From: Ron Johnson To: pgsql-general@postgresql.org In-Reply-To: <10704.1052621185@sss.pgh.pa.us> References: <6754.1052582402@sss.pgh.pa.us> <1052591490.26574.161.camel@haggis> <10704.1052621185@sss.pgh.pa.us> Content-Type: text/plain Organization: Message-Id: <1052672090.995.13.camel@haggis> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.2.4 Date: 11 May 2003 11:54:50 -0500 Content-Transfer-Encoding: 7bit X-Spam-Status: No, hits=-44.3 required=5.0 tests=BAYES_10,EMAIL_ATTRIBUTION,IN_REP_TO,QUOTED_EMAIL_TEXT, REFERENCES,REPLY_WITH_QUOTES,SIGNATURE_LONG_DENSE, USER_AGENT_XIMIAN 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/337 X-Sequence-Number: 41992 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 ? -- +---------------------------------------------------------------+ | Ron Johnson, Jr. mailto:ron.l.johnson@cox.net | | Jefferson, LA USA http://members.cox.net/ron.l.johnson | | | | The purpose of the military isn't to pay your college tuition | | or give you a little extra income; it's to "kill people and | | break things". Surprisingly, not everyone understands that. | +---------------------------------------------------------------+