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.
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 |