Re: auto insert data every one minute

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: searchelite <searchelite(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: auto insert data every one minute
Date: 2009-01-18 06:50:44
Message-ID: 1232261444.18283.1.camel@jd-laptop.pragmaticzealot.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sat, 2009-01-17 at 22:40 -0800, searchelite wrote:
>
>
> Tino Wildenhain wrote:
> >
> >
> > I wonder what is you complete problem? It seems all the advices given
> > so far are shots-in-the-dark. Could you perhaps expand a bit?
> >
> > Also for sophisticated solution, if you stick to windows you might
> > want to consider something different then just pure CMD, say some
> > scripting language to support.
> >
> > Tino
> >
> >
>
> I have pre-recorded gps data in .sql insert format..for simulate real-time
> tracking, i want to insert the data in let say every one minute

Feed the data to a loop that waits every 60 seconds. You could also pipe
it to a named pipe while an injector was listening.

Joshua D. Drake

>
> --
> View this message in context: http://www.nabble.com/auto-insert-data-every-one-minute-tp20027811p21524797.html
> Sent from the PostgreSQL - general mailing list archive at Nabble.com.
>
>
--
PostgreSQL - XMPP: jdrake(at)jabber(dot)postgresql(dot)org
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The PostgreSQL Company, serving since 1997

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Abraham, Danny 2009-01-18 15:07:36 invalid value for parameter "lc_messages": "en_US.ISO8859-1"
Previous Message searchelite 2009-01-18 06:40:09 Re: auto insert data every one minute