| From: | Doug McNaught <doug(at)mcnaught(dot)org> |
|---|---|
| To: | Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: realtime data inserts |
| Date: | 2003-05-11 16:58:43 |
| Message-ID: | m3llxdju7w.fsf@varsoon.wireboard.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers pgsql-performance |
Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net> writes:
> On Sat, 2003-05-10 at 21:46, Tom Lane wrote:
> > Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Cristina Surroca | 2003-05-11 22:19:11 | [HELP] buffers and query's |
| Previous Message | Ron Johnson | 2003-05-11 16:54:50 | Re: realtime data inserts |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | alex avriette | 2003-05-11 17:16:45 | psql inability to select a socket |
| Previous Message | Ron Johnson | 2003-05-11 16:54:50 | Re: realtime data inserts |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Lucas Adamski | 2003-05-12 07:29:50 | Re: Hack around lack of CORRESPONDING BY in EXCEPT? |
| Previous Message | Ron Johnson | 2003-05-11 16:54:50 | Re: realtime data inserts |