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