Thread: Automatic index numbers

Automatic index numbers

From
Daniel Mendyke
Date:
How can I automatically create a unique index
number when I add new data to a table?

Does this have to be done through a high level
language or does the database provide a function
for this?

-Daniel

--

To reach me remove the 'nospam.' from my address.
I can be reached at 'daniel at clacknet dot com'







Re: Automatic index numbers

From
Kees Kuip
Date:
Daniel Mendyke wrote:
> 
> How can I automatically create a unique index
> number when I add new data to a table?
> 

Try 

CREATE TABLE test
(  id serial
)