chiranjeevi.i@xxxxxxxxxxxxxxxx ("chiranjeevi.i") writes: > Is it possible to write jobs in postgresql & if possible how > should I write .please help me.:p> What do you mean by "job?" If you mean "run some sort of scheduled script," then that represents something that you could do using your favorite operating system's scheduling system. On Unix, we normally schedule batch jobs using cron. If you are running on Windows, I'm not particularly familiar with whatever it is that you would run there. -- (format nil "~S@~S" "cbbrowne" "acm.org") http://www.ntlug.org/~cbbrowne/sap.html Rules of the Evil Overlord #78. "I will not tell my Legions of Terror "And he must be taken alive!" The command will be: ``And try to take him alive if it is reasonably practical.''" <http://www.eviloverlord.com/> ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend