Re: auto insert data every one minute

From: Reg Me Please <regmeplease(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Cc: searchelite <searchelite(at)gmail(dot)com>
Subject: Re: auto insert data every one minute
Date: 2009-01-03 11:07:20
Message-ID: 200901031207.20796.regmeplease@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 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 pg_sleep?
>
> --
> View this message in context:
> http://www.nabble.com/auto-insert-data-every-one-minute-tp20027811p21263763
>.html Sent from the PostgreSQL - general mailing list archive at Nabble.com.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Aaron Burnett 2009-01-03 14:36:03 getting elapsed query times
Previous Message searchelite 2009-01-03 10:46:47 Re: auto insert data every one minute