"stephen" <mail(at)xesoftware(dot)com(dot)au> writes: > I remember with oracle there was a self numbering record id field which > we often used to cross reference tables. Is there something like this > with postgresql? You want a serial column (or maybe just a sequence). See the docs. regards, tom lane