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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general