Re: [GENERAL] auto insert data every one minute

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 window

Re: [GENERAL] auto insert data every one minute

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,

Re: [GENERAL] auto insert data every one minute

Hi Why don't use pgAgent http://pgadmin.org/docs/dev/pgagent.html ? Regards, Christophe Chauvet. Tino Wildenhain a écrit : Hi, searchelite wrote: ... i can use pg_sleep..but i have thousands of data to be inserted..is there any better way using pg_sleep? I wonder what is you complete pr

Re: [GENERAL] auto insert data every one minute

Hi, searchelite wrote: ... i can use pg_sleep..but i have thousands of data to be inserted..is there any better way using pg_sleep? 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 solut

Re: [GENERAL] auto insert data every one minute

You need to write a process that will do it. At best you can use crontab if your a lucky and use Unix. -- Fahrbahn ist ein graues Band weisse Streifen, grüner Rand On Saturday January 3 2009 11:46:47 searchelite wrote: > Daniel Verite wrote: > > searchelite wrote: > > > > > > How about usin

Re: [GENERAL] auto insert data every one minute

Daniel Verite wrote: > > searchelite wrote: > > > How about using pg_sleep ? > > INSERT ; > COMMIT; > SELECT pg_sleep(60); > > INSERT...; > COMMIT; > SELECT pg_sleep(60); > > > > i can use pg_sleep..but i have thousands of data to be inserted..is there any better way using

Re: [GENERAL] auto insert data every one minute

Grzegorz Jaśkiewicz wrote: how about windows task scheduler ? (cron-ish thing) If the OP wants to do the exact same insert every minute, then the OS scheduler sure does the job. That's not how I understood the question, though. My interpretation is that he has a SQL script with an

Re: [GENERAL] auto insert data every one minute

how about windows task scheduler ? (cron-ish thing) > > -- GJ

Re: [GENERAL] auto insert data every one minute

searchelite wrote: I have an sql script consists of insert statement data. I want to insert every row of data every one minute. How can i do that using batch file in windows How about using pg_sleep ? INSERT ; COMMIT; SELECT pg_sleep(60); INSERT...; COMMIT; SELECT pg_sleep(6

Re: [GENERAL] auto insert data every one minute

Richard Broersma wrote: On Fri, Oct 17, 2008 at 12:32 AM, searchelite <[EMAIL PROTECTED]> wrote: I have an sql script consists of insert statement data. I want to insert every row of data every one minute. How can i do that using batch file in windows Take a look at your windows sched

Re: [GENERAL] auto insert data every one minute

On Fri, Oct 17, 2008 at 12:32 AM, searchelite <[EMAIL PROTECTED]> wrote: > I have an sql script consists of insert statement data. I want to insert > every row of data every one minute. How can i do that using batch file in > windows Take a look at your windows scheduler in the control panel. Yo

[GENERAL] auto insert data every one minute

Hi all.. I have an sql script consists of insert statement data. I want to insert every row of data every one minute. How can i do that using batch file in windows Thank you -- View this message in context: http://www.nabble.com/auto-insert-data-every-one-minute-tp20027811p20027811.html Sent f