Postgres Pro
Downloads
Home   >   mailing lists

Re: auto insert data every one minute - Mailing list pgsql-general

From Daniel Verite
Subject Re: auto insert data every one minute
Date
Msg-id 47e4754c-0000-4000-8a62-d7c55cb41da1@mm
Whole thread Raw
In response to auto insert data every one minute  (searchelite <searchelite@gmail.com>)
Responses Re: auto insert data every one minute  ("Grzegorz Jaśkiewicz" <gryzman@gmail.com>)
Re: auto insert data every one minute  (searchelite <searchelite@gmail.com>)
List pgsql-general
Tree view 
    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

pgsql-general by date:

Previous
From: "Ow Mun Heng"
Date:
Subject: partitioning : replicate_partition doesn't seem to be working
Next
From: "Grzegorz Jaśkiewicz"
Date:
Subject: Re: auto insert data every one minute