"stephen" <mail@xesoftware.com.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