Hi, Thankx guys I am now able to increment that field by using serial. Richard Huxton wrote: > > Yesh wrote: >> Hi, >> >> I need to know how to increment a primary key field automatically in >> run >> time. > > Not sure precisely what you want to know, but read up on the SERIAL > type, sequences, nextval() and currval(). > > -- > Richard Huxton > Archonet Ltd > > ---------------------------(end of broadcast)--------------------------- > TIP 1: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your > message can get through to the mailing list cleanly > > -- View this message in context: http://www.nabble.com/About-auto_increment-tf2906530.html#a8135523 Sent from the PostgreSQL - general mailing list archive at Nabble.com.