Re: record id

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "stephen" <mail(at)xesoftware(dot)com(dot)au>
Cc: "'Postgresql'" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: record id
Date: 2007-04-26 23:58:38
Message-ID: 28806.1177631918@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

"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

In response to

  • record id at 2007-04-26 22:48:15 from stephen

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2007-04-27 00:04:23 Re: How long does commit take?
Previous Message Phillip Smith 2007-04-26 23:25:19 Re: cannot insert or update