Re: auto insert data every one minute

From: "Daniel Verite" <daniel(at)manitou-mail(dot)org>
To: "searchelite" <searchelite(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: auto insert data every one minute
Date: 2008-10-18 09:35:51
Message-ID: 47e4754c-0000-4000-8a62-d7c55cb41da1@mm
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(60);

...

Best regards,
--
Daniel
PostgreSQL-powered mail user agent and storage:
http://www.manitou-mail.org

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Grzegorz Jaśkiewicz 2008-10-18 09:42:01 Re: auto insert data every one minute
Previous Message Ow Mun Heng 2008-10-18 08:19:19 Re: partitioning : replicate_partition doesn't seem to be working