| From: | Jeff Boes <jboes(at)nexcerpt(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: continuous data from stdin |
| Date: | 2003-02-18 18:34:30 |
| Message-ID: | 3e52779e$1_4@news.teranews.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, 18 Feb 2003 13:09:45 -0500, ÷ÅÒÅÔÅÎÎÉËÏ× áÌÅËÓÅÊ wrote:
> I think it's a common question, though I couldn't find any information
> aboo= ut it so far. I've got a program that puts its logs into stdout.
> What is th= e best solution to insert these logs into a table as they
> occur?
I think you're going to have to write a program (Perl using DBI would be
my choice) to use this output as input, and do INSERT statements as each
record is received. (The COPY command in SQL won't do the trick, if
that's what you're thinking of.)
--
Jeff Boes vox 269.226.9550 ext 24
Database Engineer fax 269.349.9076
Nexcerpt, Inc. http://www.nexcerpt.com
...Nexcerpt... Extend your Expertise
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mike Mascari | 2003-02-18 18:38:36 | Re: a function problem... |
| Previous Message | Harry Broomhall | 2003-02-18 18:20:52 | Re: continuous data from stdin |