On 1 Jan 2007 at 21:21, Yesh wrote: > I need to know how to increment a primary key field automatically in > run time. Use type SERIAL as your primary key - here is the relevant page in the docs: http://www.postgresql.org/docs/8.2/static/datatype- numeric.html#DATATYPE-SERIAL HTH, --Ray. ---------------------------------------------------------------------- Raymond O'Donnell Director of Music, Galway Cathedral, Galway, Ireland rod@xxxxxx ----------------------------------------------------------------------