Horton

Re: realtime data inserts

Douglas McNaught <doug@mcnaught.org>

View thread View on postgr.es
From: Doug McNaught <doug@mcnaught.org>
To: Ron Johnson <ron.l.johnson@cox.net>
Cc: pgsql-general@postgresql.org
Date: 2003-05-11T16:58:43Z
Lists: pgsql-hackers, pgsql-performance, 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