Re: realtime data inserts - Mailing list pgsql-general

From Doug McNaught
Subject Re: realtime data inserts
Date
Msg-id m3llxdju7w.fsf@varsoon.wireboard.com
Whole thread Raw
In response to realtime data inserts  ("Adam Siegel" <adam@sycamorehq.com>)
Responses Re: realtime data inserts  ("alex b." <mailinglists1@gmx.de>)
List pgsql-general
Ron Johnson <ron.l.johnson@cox.net> writes:

> On Sat, 2003-05-10 at 21:46, Tom Lane wrote:
> > Ron Johnson <ron.l.johnson@cox.net> 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

pgsql-general by date:

Previous
From: Ron Johnson
Date:
Subject: Re: realtime data inserts
Next
From: "Cristina Surroca"
Date:
Subject: [HELP] buffers and query's