Thread

Antw: Automatic index numbers

Gerhard Dieringer <dieringg@eba-haus.de> — 2000-05-18T06:52:32Z

>>> 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