| 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: | Whole Thread | Raw Message | 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 |