Re: auto insert data every one minute - Mailing list 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.