Create a column with type SERIAL in the table, or if you want to have
programmatic access to the number while you're handling the update, use a
sequence.
Don't take this as a flame, but if you're doing a lot of work with
PostgreSQL, you really ought to buy the book. No conflict of interest
here, just another satisfied reader...
Ciao
--Louis <louis@bertrandtech.on.ca>
On Thu, 11 Jan 2001, Julio Cuz, Jr. wrote:
> Hi--
>
> I'm using phppgadmin for pgsql, how do i create a field called (i.e. ID)
> that INCREASES by ONE AUTOMATICALLY each time a record is added? I want
> pgsql to add it automatically.
>
> Thanks.
>
> Julio Cuz, Jr.
> Riverside Community College
> jcuz@rccd.cc.ca.us
>
>