Thread: Antw: Automatic index numbers

Antw: Automatic index numbers

From
"Gerhard Dieringer"
Date:
>>> daniel@clacknet.com 18.05.2000  02.52 Uhr >>>
>
> 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

You can use a column with datatype serial or an integer with default nextval('a_sequence')

Gerhard